The following is a session that was a full blown trigger test, even though the voc name is FAKE.TRIGGER.PHENOM. It wrote 17 fields into every GAF (an audit file) record including the differences between before and after (all were inserts) on a field by field basis of the data record. I would expect some IO time as well as record locking and all the other overhead on the TRIGGERED item.
The only edits on this report are the prompts, which indicate the system name and account and the comments that might show up in red. Given the breadth of the trigger functionality in this case, I'm thinking that the 15 percent hit is worthwhile. john >FAKE.TRIGGER.PHENOM Adding trigger "TEST.WORK" File "WORK.MATCH" has been cleared. clear the data file 10000 record(s) selected to SELECT list #1. try to match 10000 input records 1000 2000 3000 4000 5000 6000 7000 8000 9000 10000 373 SECONDS Dropping all triggers now run it without the trigger File "WORK.MATCH" has been cleared. 10000 record(s) selected to SELECT list #1. 1000 2000 3000 4000 5000 6000 7000 8000 9000 10000 324 SECONDS >SELECT GAF 7900 record(s) selected to SELECT list #0. >>DATE used to clear the select list Internal:13396 External:03 SEP 2004 Time Int.:61784 External:17:09:44 >SELECT WORK.MATCH 7900 record(s) selected to SELECT list #0. >>DATE Internal:13396 External:03 SEP 2004 Time Int.:61793 External:17:09:53 > -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: Friday, September 03, 2004 3:19 AM To: [EMAIL PROTECTED] Subject: RE: [U2] Anyone have experience "mirroring" a HDD over a WAN Jeff Triggers that have little effect on performance would indeed be ideal. Alas, our experiments (prompted by Adrian Matthews post) have lead to the firm decision to stay away from triggers as implemented in UniVerse... A trigger that merely activated (ie a two line program having a RETURN statement as line 2) doing nothing takes 10 to 15 times as long to complete eg without a trigger, 500 000 records takes 60.3 secs to copy with a empty trigger, 500 000 records took between 600 & 700 secs!!! This sure sucks! -----Original Message----- From: Lettau, Jeff [mailto:[EMAIL PROTECTED] Program triggers that keep all the databases updated virtually in real time sounds like the best real world solution to me. <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/ This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
