A trigger need not necessarily be intensive - tho' admittedly the concept of an audit or any process requiring a write will mean the extra overhead of that write.
The thing to watch out for is the temptation to read lots and write lots... Then imagine this blowing out exponentially as 3 zillion records are written, read, updated, and deleted. If, however, you intend to entirely cripple a site, you could always add triggers to update files that in turn have triggers that update others in a sort of "round-robin"... just imagine, what overhead that would involve! <smile> As for replication - just add another hardware controller to machine - every write will initiate two hardware writes --> no lag, overhead, everything instant. -----Original Message----- From: Adrian Matthews [mailto:[EMAIL PROTECTED] Sent: Tuesday, 31 August, 2004 9:02 AM To: [EMAIL PROTECTED] Subject: RE: [U2] Dot Commands Bear in mind though that a trigger is a very intensive thing to add to a file. Just try timings on writes with and without them. Also you cannot replicate a file with triggers (major problem for use that I would LOVE IBM to fix.....) <PRE> --------------------------------------------------------- GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH Coetzee, JGD Smit, JF Jacobs, AO M|ller, JW Smit, JP Snyman, JG Stander, JH van Dyk(MD/BD), JG Jacobs, A M|ller, M van Zyl, Sekr/Secr: E van Niekerk. Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by: http://www.gwk.co.za/DisclaimerVrywaring.asp This e-mail is subjected to the disclaimer that can be viewed at: http://www.gwk.co.za/DisclaimerVrywaring.asp</PRE> ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
