Say you have a query that returns a resultset of 500 rows. Bad for a browser! Naturally you will have to only return a subset of that resultset, say only 50 ouf of that 500.
What is the best, most efficient method of doing this? My query would wind up looking like this:
$sql = 'SELECT * FROM BLAH LIMIT 50';
And for subsequent next 50:
$sql = "SELECT * FROM BLAH WHERE id > $maxID LIMIT 50";
How can I most efficiently accomplish this? I am hoping I will not have to re-query every single time, furthermore, were I to use ADODB to cache the resultset, could I vary the SQL query and pull from the .cache file accurately and efficiently? Or would you recommend an entirely different approach to this?
I've never been able to figure this aspect of Content Management out! 🙁
Thanx
Phil
