Answer 1: For many cases you can use the bundled tools. Your case isn't typical, it seems, because of the processing time your queries require. The normal case for pagination is to use ajax to update the table, with the query having a limitby stipulation; this is typically fast enough for most people. Improvement can be done by using caching, but the size of your results may make caching impractical. Answer 2: web2py provides a simple backend that often can get a website done quickly. The default frontend tools provide a good starting point for Datatables provides advanced frontend features that can be used to make the user experience feel more like a spreadsheet. Your users in particular may appreciate that, since they are manipulating the data presentation. If you had insight into what the users were looking for during their examination of the data, you may be able to provide a better query that could simplify the data presentation. But perhaps there is no pattern shared by the different users, and you'd end up with a separate query for each user. /dps -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.