Performance in MySQL Result Question

From: Date: Sat, 15 Mar 2003 08:57:43 +0000
Subject: Performance in MySQL Result Question
Groups: php.db 
Request: Send a blank email to php-db+get-26393@lists.php.net to get a copy of this message
Hi, I've got a page with lot's of visitors every day and I sure hope to get more, so I'm already thinking of performance. This is what I've got. Users select one or more things out of a couple drop down menus, no big deal. Their selection is than shown, with a limitation of 20 results on the page. 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? What would be your choice? I'm open to suggestions, maybe somebody has a totally different idea. The limitation of 20 is a wish of my customer. I think, most vistors won't stay on page one, but will click thru some pages further. The max. number of results shown should be around 1000 hits. Jan

« previous php.db (#26393) next »