The speed issue is not in the subroutine itself. I tried a subroutine that did nothing, just a return and the process takes 25 seconds compared to 2 seconds with out a trigger. My main trigger subroutine is using a common for the file opens and that did cut the processing time down from 2 minutes to 25 seconds, but 25 seconds still seems pretty slow.
Does Universe require any special settings for triggers? Or file types? Does the account have to be a specific flavor of Pick? Permissions? I don't know any other thoughts or suggestions? My searches have not turned up anything useful but someone's post did say that they found it to be slow on 10.2 but they did not elaborate or get a response that I found. Thanks for your help. Curt -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Friday, October 30, 2009 10:38 AM To: U2 Users List Subject: Re: [U2] Universe Triggers is the trigger program doing any file opens? That would probably be your slow down. I've not tried to setup a common with any of the triggers I've setup, since the number of writes has been minimal for us (maybe 5 per hour maximum). George > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Curt Stewart > Sent: Friday, October 30, 2009 10:47 AM > To: u2-users@listserver.u2ug.org > Subject: [U2] Universe Triggers > > I'm testing using triggers to maintain an Audit log of transactions. > Everything works, the file, the subroutine, but the trigger process is > extremely slow. > > My test program loops through 1 to 10000 and writes a record to my > test file with the trigger. Without the trigger in place the program > runs in 2 seconds, with the trigger in place the program runs in 25 > seconds. The timings are roughly the same if the trigger program is > doing nothing more than a return. I've also tested calling the > trigger subroutine from the program (without the trigger on the file) > and the process runs in 2-3 seconds. > > This is Universe 10.2.10 on a virtual Windows 2003 server. The > trigger file is type 18 and the trigger was created with this > statement; CREATE TRIGGER AUDIT_LOG BEFORE UPDATE OR INSERT OR DELETE > ON TEST.TRIGGER.FILE FOR EACH ROW CALLING '*apps*AUDIT.LOG.TRIGGER'; > > It appears that just calling a trigger significantly degrades the > process. > Does anyone have any ideas or suggestions. > > Thanks for any help you can provide. > Curt > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
