mos wrote:
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
This require the change of Mysql engine. I wish Mysql has such configuration option for that in future release.
Sam
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]