Could it be that the ORDER BY 1 comes from the default sort order set on the form? If it is causing severe performance degradation I guess you should see your DBA.
-- Michiel On 10/11/06, STAN HOLODNAK, BLOOMBERG/ 731 LEXIN <[EMAIL PROTECTED]> wrote: > I just added $ars_errstr to printout. I also indexed fields on which I am > searching and I did not see an error yet, because GetListEntry always > returned > something I guess. The response time for the query varies from 30 seconds to > 200 > seconds. So this query > '%entries = ars_GetListEntry( $ctrl, $form, $qual , 0 , 0);' produces > this query > that's the one SELECT T431.C1,T431.C1,C536871066,C536871068,C60 > 0000200,C536870935,C8,C7,C536870953,C536870924,C536871044,C53687 > 0937 FROM T431 WHERE (((T431.C600000200 = 'SWDRData') AND > (T431.C7 < 5)) AND (T431.C2 = 'nams')) ORDER BY 1 ASC > When I remove 'ORDER BY 1 ASC' clause it returns right away, but with the > 'ORDER' there are delays. I don't need 'ORDER BY 1 ASC', how can I remove it? > Also is there some kind of timeout for the function? -Stan > > ----- Original Message ----- > From: Richard Hellier <[email protected]> > At: 10/10 7:53:36 > > Stan, > In the "bad" cases, what is in $ars_errstr? > > Cheers > > Richard. > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of STAN HOLODNAK, > BLOOMBERG/ 731 LEXIN > Sent: 10 October 2006 10:31 > To: [email protected] > Subject: [Arsperl-users] GetListEntry returns empty sometimes > > I have a script (daemon) that runs GetListEntry every 10 minutes. LAtely > I've > noticed that at times GetListEntry returns empty despite of the form having > data > for that qualification. What is the reason for that? -Stan Holodnak > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys -- and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Arsperl-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/arsperl-users > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys -- and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Arsperl-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/arsperl-users > > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > Arsperl-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/arsperl-users > ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Arsperl-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/arsperl-users
