[mod_python] Perfect solution for split recordset by N number of records per page

Mike Looijmans nlv11281 at natlab.research.philips.com
Thu Sep 28 06:51:56 EDT 2006


> You probably need to think about tuning your database a bit to see if you can 
> speed things up.  Make sure that you have the correct indices in place and 
> than you are using limit/offset as best you can.  This is really a database 
> problem as much as a web app design issue.  In other words, if your SQL query 
> to get a "page" of data takes 3 seconds, this is a database issue, which I 
> suppose it is.

It's also a UI issue. Who would want a user to browse through 10000 records in pages of 100 records? 
The UI should allow some method of limiting or summarizing the results.



More information about the Mod_python mailing list