Pagination on Random Result Set ? |
[eluser]sophistry[/eluser]
maybe try not to store the entire result set in a session - it can get slow if you put too much data in a session variable because (generally speaking) sessions write/read the hard disk and are loaded on every page view where sessions are invoked. i haven't done this but it is an interesting problem... here's something to try: PHP's array multisort store an array of unique ids (primary keys from your main random recordset) in a session var. then, just use the ids for subsequent db queries and sorting (using array_multisort() ). |
Messages In This Thread |
Pagination on Random Result Set ? - by El Forum - 07-09-2007, 12:50 PM
Pagination on Random Result Set ? - by El Forum - 07-09-2007, 03:27 PM
Pagination on Random Result Set ? - by El Forum - 07-10-2007, 11:32 AM
Pagination on Random Result Set ? - by El Forum - 07-10-2007, 12:30 PM
Pagination on Random Result Set ? - by El Forum - 07-11-2007, 04:09 PM
Pagination on Random Result Set ? - by El Forum - 07-11-2007, 08:28 PM
|