Thanks for your prompt response.
I am using sqlite database.I placed {{=response.toolbar()}} in view and
found that, query which is being used in SQLFORM.grid is taking more time
than others.
Please find below the query and time taken to execute:
SELECT table1.device, table1.user, table1.type, t
I mentioned wrong data for the query which SQLFORM.grid is executed so
sorry for that, basically that query is taking 0.00 ms and below query has
taken 32.00 ms:
SELECT count(*) FROM table1 WHERE (table1.id > 0);
On Fri, Feb 22, 2013 at 2:24 PM, Niphlod wrote:
> wonderful. thanks.
> @newbie:
I cross-verified and got the same result , timings is 32.00 ms for count
query.Anyways, please find below the model and controller code:
Model:
db.define_table('table1',
Field('device', type="reference devices", ondelete="SET NULL"),
Field('type', 'integer'),
Field('message', 'string', r
Hi All ,
Thakyou for the reply..actually the real problem was,after the grid
was created,we were using a query to fetch the latest record from the
database.That query was again traversing 1 lakh records and therefore it
was taking time.After replacing the query
with latest_record=db.table1.
4 matches
Mail list logo
