Hey John, I have used datatables with web2py in some projects and it was faster than smartgrid when used in server mode. Whenever I had performance problems was because the code used .count() to show the total number of records. In my case the tables have several millions of records and that was way too slow. That's a common problem in many databases engines, not a datatables problem.
When using an aprox. number instead of executing the sql count() command, the datatable works fine showing hundred of rows from a table. You have to make your own code for the server side, to support filter or sort if you need them, but it's quite straightforward. José L. El jue., 16 may. 2019 a las 11:42, John Bannister (<eudoraj...@gmail.com>) escribió: > Hi All, > > I have a number of web2py applications that use the grid/smartgrid > functionality pretty heavily. The majority of the applications are working > with large data sets (some tables have > 20M records) and everything runs > fine. > > With the coming of Web3Py (which looks great) my question is what would be > a viable equivalent to web2py's grid/smartgrid? > > I looked at Datatables some time back which worked great on smaller > datasets but anything over 50K (on my testbed) starts to become unusable. I > also implemented some server side processing for Datatables but never quite > managed to get a usable solution or at least nothing that could handle big > data sets as efficiently as web2py. > > So basically looking for something that can handle large datasets that > will plug into web3py if anyone has any recommendations they would be much > appreciated or if anyone has managed to get Datatables working well with > large data sets some guidance would be great. > > Thanks in advance > > -- > 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. > To view this discussion on the web visit > https://groups.google.com/d/msgid/web2py/8e109e58-f4ac-4272-a835-d86e5101c7fe%40googlegroups.com > <https://groups.google.com/d/msgid/web2py/8e109e58-f4ac-4272-a835-d86e5101c7fe%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/CAHpm-q2R19-kd7VqSMmEQbFL7ggKG3d_2UHMz_uF3E7WkMPQjw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
