Phil, My test file is 1009,1 type 18. My record id is just a sequential number 1 to 10,000 for this test file and the data is only 40-50 more bytes. So I don't think the file size is the problem. I've tested the logic by calling the trigger subroutine direct from the program and I get a 2 second process time, so I don't think the logic is the problem either.
Are you on Universe or Unidata? Thanks for the response. Curt Stewart TRI-SYS Consulting Integrated Multi-Value Business Solutions -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of phil walker Sent: Friday, October 30, 2009 5:39 PM To: U2 Users List Subject: Re: [U2] Universe Triggers Check your file sizes out or your logic, because I experience nothing like this still subsecond responses, and we use triggers for auditing/data quality/ and replication through a log/webservice to sql, although the later part of that is handled asynchronously.... > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Curt Stewart > Sent: Saturday, 31 October 2009 6:45 a.m. > To: 'U2 Users List' > Subject: Re: [U2] Universe Triggers > > 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 > _______________________________________________ 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