In my case I didn't activate server side processing, I instead reduce the length of the dataset to be displayed by year slicing... I had buttons to specify which years of data the user wants and an "All" button with a notice it could be long to load... It has reduce the load time of the page...
Someone can also, improve speed by not using pydal and instead make a raw sql query bypassing all the pyDAL parsing of records and dictionnary creation (db.table.fieldname) which are costy... You then rely on python slicing to get you data column by colomn... On Sat, Jul 29, 2017 at 8:13 AM, villas <villa...@gmail.com> wrote: > Thanks for responses and José that code will be a good help. > > In my case, parsing the query is quite trivial to extract a search string > and the sort order, which is all I needed just now. > > After playing around more, it seems to me that Web2py would be really > improved with something like Datatables (as well as the sqlform grid). > > - For small datasets you can feed in all the data at once and use js > pagination and searching etc. It's quick and avoids a lot of queries. > - For large datasets, the ajax interaction is great. > > > The number of queries that the sqlform grid produces is very inefficient, > and that is why I have been experimenting with Datatables in the first > place. > > Indeed Datatables seems to fit really well with Massimo's ideas for the > future (I mean making better use of the client-side and reducing > bandwidth). > > Best regards. > > > -- > 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. > -- 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.
