Phil, This appears to be a Windows bug. I ran my test program on a Universe 10.3 AIX box and it also took just 2 seconds.
Does anyone know if this bug is scheduled for resolution? Thanks everyone, for all the help 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: Saturday, October 31, 2009 1:05 AM To: U2 Users List Subject: Re: [U2] Universe Triggers Universe 10.3.1 RHEL 4.x and 10.1.13 Dec Alpha > -----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 5:46 p.m. > To: 'U2 Users List' > Subject: Re: [U2] Universe Triggers > > 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 > _______________________________________________ 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