Real time logging to sql database

[Chris Trudeau]

Yep...exactly the design that Julian/Steve had in mind (I assume).

The MailWatch package uses temp files as well I believe...it IS however a
great solution...

CT

----- Original Message -----
From: "David H." <dh at UPTIME.AT>
To: <MAILSCANNER at JISCMAIL.AC.UK>
Sent: Monday, December 22, 2003 4:09 PM
Subject: Re: Real time logging to sql database


> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: RIPEMD160
>
> Paul Hamilton wrote:
>
> > Hi all,
> Hello.
> >
> > Is there anybody using real time logging for Mailscanner to a
> > sql database per message, rather than generating temporary
> > files and flushing every restart?
> >
> Just some general thought. I wonder how secure this is and what kind of
> performance hit one has to take. Theorethically, if I wish to do this
> "securely" each log message has to be its own transaction. Thus a
> singular INSERT results ina full transaction within the database. Now,
> when I imagine I have a fiarly busy MailServer with, let's say, 0.5 or 1
> message per second, that might nag on the database a whole lot when I
> log _directly_ into the Daemon.
>
> Maybe it is indeed faster to simply write out SQL INSERT statements into
> a file, to the disc and sync this file into the database every 15 or 30
> minutes. This could be done in a single transaction then.
>
> But then again, I am by far no Database guru.
>
> - -d
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.3 (Darwin)
>
> iD8DBQE/5112PMoaMn4kKR4RA9mbAJ4rOPYzjnGcL9kus9eT1poJ/ZSwUQCeN57j
> 9L4MUB1vnC6x/zh6nRxBtFs=
> =tSih
> -----END PGP SIGNATURE-----