6 PM
To: arslist@ARSLIST.ORG
Subject: Re: Search Results Returned Limit
** Kali,
How things work depends on the version of the AR System server you are using.
Older servers (pre about 2005)
The DB query searches and builds its internal list, our code then gets the
next item from the list in a loo
Re: Search Results Returned Limit
** Kali,
How things work depends on the version of the AR System server you are using.
Older servers (pre about 2005)
The DB query searches and builds its internal list, our code then gets the
next item from the list in a loop
adding them to a memory structure
Kali,
How things work depends on the version of the AR System server you are using.
Older servers (pre about 2005)
The DB query searches and builds its internal list, our code then gets the next
item from the list in a loop
adding them to a memory structure for return to the client. When we hi
My understanding is that in ARS 7.5, an extra "top xxx" is added to the SQL
statement in sql server databases and a extra " AND ROWNUM < " is
added to Oracle ones.
I can't remember what is the syntax for DB2
So for instance in Oracle
SELECT C1.T500, C2.T500 FROM T500 where C2 = 'Demo
Kali,
I haven't double checked with recent versions, but in the past it only
limited what was displayed and not what was actually queried.
I really don't expect that to ever change since the database has to
query the whole set if there is a sort.
The SQL log will show the query as it is sent to t
5 matches
Mail list logo