I beg to differ. I created a trigger program that does nothing; just the subroutine header and a RETURN.
Creating a series of records took 17 seconds without the trigger and 291 with it. Quite an overhead I'd say. Adding hardware won't sort the replication problem. Universe will not allow a published or subscribed file to have triggers on it. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: 31 August 2004 09:18 To: [EMAIL PROTECTED] Subject: [U2] Trigger not intensive, it's what you do with trigger! Was RE: [U2] Dot Commands 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/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/