[snip] > Now comes my question, what is better speaking of performance: > When users go on to the next page, is it better to > provide the select statement again with a different integer for > the limit? > > Or is better to do a full select without a limitation on first page. > But than I don't know how to provide the result set for the > next, next, ... page? [snip]
Use a limit, it's efficient. You can't do a full select on one page and somehow carry the result over to another page with any kind of efficiency. ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
