Hello Michael,
On 04-Feb-01 21:23:26, you wrote:
>AFAICT there is no 'LIMIT' feature in MS SQL products (TOP and supposedly
>BOTTOM, but BOTTOM has never worked for me and TOP doesn't seem to work on
>all versions).
>How is metabase handling this? Pulling everything, looping thru, and only
>returning the requested rows?
No, Metabase use server side cursors. It just seeks for the first row that
it is requested and starts fetching rows from there. It works on MS SQL 6.5
on which the TOP clause is not available.
>Yes, I could log in/download/uncompile and spend the next 20 minutes finding
>it for myself, but I'm in the midst of work! ;) And getting and explanation
>from the horse's mouth might be more instructive anyway. !!!
:-)
Ok, now that you got your explanation you may download Metabase to look in
for the details.
http://phpclasses.UpperDesign.com/browse.html/package/20
Regards,
Manuel Lemos
Web Programming Components using PHP Classes.
Look at: http://phpclasses.UpperDesign.com/?[EMAIL PROTECTED]
--
E-mail: [EMAIL PROTECTED]
URL: http://www.mlemos.e-na.net/
PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp
--
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
