SQL Redux

Julian Field mailscanner at ecs.soton.ac.uk
Mon Aug 4 19:47:36 IST 2003


At 14:29 04/08/2003, you wrote:
>If there's really no performance hit to logging after every email instead of
>in batches, I'll see about changing my code to do it that way too. Nothing
>worse than having to wait for all of the children to finish logging before I
>can do a full restart of MailScanner.

There must be a significant performance hit. In one case you are just
appending a line to a file. In the other case you are adding a record to a
database table and updating various indices. This *has* to be a much bigger
operation than just adding 1 line to a file.
--
Julian Field
www.MailScanner.info
Professional Support Services at www.MailScanner.biz
MailScanner thanks transtec Computers for their support



More information about the MailScanner mailing list