Thanks Doug, That's pretty much the conclusion I came to after I ran my test on a 10.3.3 Universe system.
Unfortunately, this application doesn't use a common WRITE or DELETE routine, so I get to update about 90 programs with the audit logic. It'll be tedious but not too bad. Thanks for the feedback Curt Stewart TRI-SYS Consulting Integrated Multi-Value Business Solutions www.tri-sysconsulting.com -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Sent: Friday, October 30, 2009 12:19 PM To: 'U2 Users List' Subject: Re: [U2] Universe Triggers Curt, We run Web applications a 25 second delay would be a death march for our staff with the users pointing things at us. This is a known Universe issue and to be fixed on a later release according the folks at U2 University. We wrote our own auditing the works with Universe and Unidata. This is pretty easy for us since high percentage of our writes and deletes are handled out of a single subroutine. The programs that use their own WRITE or DELETE had to have all another line or two added to complete the auditing processes. We have about a 50-300ms delay for the additional read and writes to the audit file. This strategy works very well for our call center application. Regards, Doug -----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:37 AM To: 'U2 Users List' Subject: Re: [U2] Universe Triggers 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 _______________________________________________ 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
