At 07:01 PM 3/10/2005, Chris W. Parker wrote:
Homam S.A. <mailto:[EMAIL PROTECTED]>
    on Wednesday, March 09, 2005 5:09 PM said:

> If your tables are mostly read-only, you could
> pre-generate page numbers on a periodic basis and
> select only specific ranges WHERE row_number BETWEEN
> page_start AND page_finish.

How about just getting the entire list on the first page and then on all
subsequent pages using LIMIT()?



Chris.

Chris,
This is deja vu all over again.<vbg>
I already suggested this. He needs the record count and Limit doesn't provide it. And separate Sql Count would be too slow.


Mike


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to