On Fri, Aug 16, 2002 at 11:19:18AM +0200, Manfred Koizar wrote:
> do you *need* to update event_stats in a trigger? What I mean is, if
Well, of course I don't need to, but given that that table is not only
inserted into, but also updated, I'd rather have the stats kept in sync
by the trigger than in the application -- if not, I could use mysql.
I did a big import (3.7 mio rows) and it worked out pretty well with
the regular vacuum -- 50 rows/sec on average, and no more sawtooth
pattern.
Regards,
cm.
--
Christian Mock Wiedner Hauptstrasse 15
Senior Security Engineer 1040 Wien
CoreTEC IT Security Solutions GmbH +43-1-5037273