Hi, I'm a complete beginner on Web2py. I have to write a complex reporting app (no CRUD, just read only reports (tables, graphs and Excel download possibilities), around 50 reports. The database is already given, so I do not want to create any table, instead of that I have to run big and complex selects, mainly included in the stored procedures hosted on our big MSSQL database
My question is: Is Web2py designed to be used for such purpose and can it be used to display to the users several thousands rows (of course paginated or displayed as a graph based on that data)? So how you are dealing with the (possibly client side) pagination as of course I do not want to run the whole stored proc again and again just to retrieve the next 25 rows. The database is big (several hundreds of tables with lots of them over 100 millions of rows. Some complex stored procs are running 3-5 secs and once the data is ready to be delivered to the client, I would like to treat it on the client side (filtering, sorting, exporting, etc) If the answer is yes, what table component is used for that and how a client side paging is implemented Any help would be appreciated. If you could drive to an already working example that would be fantastic -- 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.
