|
|
Posted by Richard Levasseur on 03/14/06 00:21
I had to make something very similar for a mailing list, ~5000 records.
Store the query information (not the data/result set) in session, this
mean the start/count for the LIMIT clause
What i would do is use get requests to specify the offset
?start=10&number=100
or just hide the start/number by doing ?page=5, and do the calculation
for offset/count in the php
?start=all to show all records
processing that much is going to be slow and may bog the browser down.
It may be better to send a csv file so they can view it in excel,
instead.
If you're dealing with large results sets, I'm willing to bet PHP will
bog down (if you're storing it all into an array or something) before
the database server begins to bog down.
Navigation:
[Reply to this message]
|