Thread: Re: [Arsperl-users] GetListEntry returns empty sometimes
Brought to you by:
jeffmurphy
Menu
▾
▴
arsperl-users
|
From: STAN H. B. 7. L. <sch...@bl...> - 2006-10-11 15:14:21
|
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
|
|
From: Vaughan, M. <Mar...@ca...> - 2006-10-11 15:40:44
|
Stan,
You can use ars_GetListSQL and do the query directly to the DB, but have
to know exactly which table.
Hope that helps,
Mark Vaughan
Comcast Cable Corporation
720.268.8591
-----Original Message-----
From: ars...@ar...
[mailto:ars...@ar...] On Behalf Of STAN HOLODNAK,
BLOOMBERG/ 731 LEXIN
Sent: Wednesday, October 11, 2006 8:59 AM
To: ars...@ar...
Subject: Re: [Arsperl-users] GetListEntry returns empty sometimes
I just added $ars_errstr to printout. I also indexed fields on which I
am=20
searching and I did not see an error yet, because GetListEntry always
returned=20
something I guess. The response time for the query varies from 30
seconds to 200
seconds. So this query
'%entries =3D ars_GetListEntry( $ctrl, $form, $qual , 0 , 0);' produces=20
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 =3D 'SWDRData') AND
(T431.C7 < 5)) AND (T431.C2 =3D 'nams')) ORDER BY 1 ASC
When I remove 'ORDER BY 1 ASC' clause it returns right away, but with
the=20
'ORDER' there are delays. I don't need 'ORDER BY 1 ASC', how can I
remove it? =20
Also is there some kind of timeout for the function? -Stan
=20
----- 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=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDE
V
_______________________________________________
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=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDE
V
_______________________________________________
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=3Dlnk&kid=3D120709&bid=3D263057&dat=3D=
121642
_______________________________________________
Arsperl-users mailing list
Ars...@ar...
https://lists.sourceforge.net/lists/listinfo/arsperl-users
|
|
From: Michiel B. <mic...@gm...> - 2006-10-12 06:55:30
|
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 > |
Thanks for helping keep SourceForge clean.
X