If only I had a penny every time in a changelog there is a "big number" speedup and all users starts making questions.....I knew those "x% faster" will have raised more questions than answers.
SQLTABLE take the rows after they have been fetched. SQLTABLE is for displaying results only. SQLFORM.grid or smartgrid take tables or queries, and the grid is in charge to fetch those records (based on the parameters you use) for every request. The grids paginate, order, edit, create, export, find related tables, etc etc etc. If you are going to use SQLFORM grids you can't "use" any improvement regarding "the cache side". Il giorno giovedì 30 agosto 2012 12:05:55 UTC+2, Johann Spies ha scritto: > > I am afraid I do not understand you reasoning: > > I can do > > rows = db(db.sometable).select( > cacheable=True, cache = (ram.cache,3600)) > data = SQLTABLE(rows) > > or I can do > > query = db.sometable.id>0 > data = SQLFORM.grid(query) > > or > > data = SQLFORM.smartgrid(db.sometable) > > and how do I use those improvements in the latter 2 cases. That is what I > have asked in my first email. > > So what do you mean that it has nothing to do with grid/smartgrid where > both of them run queries? > > Regards > Johann > > > >> --
