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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]