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,
That *may* be good to hear. I've used other databases that keep record counts in the index so any Select statement will return an accurate and fast record count. However it slows down the inserts/updates as it has to maintain these index counts as each record is added. So I hope this new mySQL feature can be turned off if necessary. You usually don't get a new feature like this without a speed penalty somewhere.
Mike
Sam
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
