Re: [Arsperl-users] GetListEntry returns empty sometimes

[Michiel B. <mic...@gm...>]

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
<sch...@bl...> 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  <ars...@ar...>
> At: 10/10  7:53:36
>
> Stan,
>    In the "bad" cases, what is in $ars_errstr?
>
> Cheers
>
> Richard.
>
>
> -----Original Message-----
> From: ars...@ar...
> [mailto:ars...@ar...] On Behalf Of STAN HOLODNAK,
> BLOOMBERG/ 731 LEXIN
> Sent: 10 October 2006 10:31
> To: ARS...@AR...
> 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
> Ars...@ar...
> 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
> Ars...@ar...
> 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
> Ars...@ar...
> https://lists.sourceforge.net/lists/listinfo/arsperl-users
>