Re: db paging with MS Sql

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/?user=mlemos@acm.org -- E-mail: mlemos@acm.org URL: http://www.mlemos.e-na.net/ PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp --