PHP Pear - Regarding SQL Server paging: Solutions

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Regarding SQL Server paging: Solutions

Markus Wolff

2004-08-06, 8:56 am

Hi there,

not really a PEAR topic, but it has been asked countless times on this
list how to get paged resultsets from a Microsoft SQL Server, which
doesn't support LIMIT (or at least doesn't support offsets).

I've just stumbled upon an article on CodeProject that not only shows
several different methods on how to achieve paged results with MSSQL,
but also provides benchmark results for each of these methods. Although
it refers to using ASP.NET datagrids, the article's focus is on raw SQL,
so all of it can easily be applied to PHP.

Here's the link:
http://www.codeproject.com/aspnet/PagingLarge.asp

HTH,
Markus

Sponsored Links