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