|
Posted by comp.lang.php on 03/13/06 20:55
jonathan.beckett wrote:
> Don't do it. You'll kill the webserver. It's also just an incredibly
> bad way of doing it.
>
Why? Wouldn't hitting the database hundreds of times be even worse?
> You should be forming queries that limit the resultset and provide the
> results on demand.
>
> With MySQL you can do something like...
>
> SELECT foo FROM bar LIMIT x,y
>
> ... where x and y are the start record, and number of records to grab.
Yeah but the customer demands that they be able to do this:
1) Sort all of the existing records by multiple fields
2) Search all existing records according to a fulltext field
3) Be able to view Page 127 or 40 or 3 or whatever entirely on the fly
WHILE looking at the paginated 10 - 20 records that they are able to
see upfront.
Phil
Navigation:
[Reply to this message]
|