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 <niph...@gmail.com> wrote: > wonderful. thanks. > @newbie: can you see how many seconds it takes the query that has a > count() in it ? that one is probably taking more than a few millisec. > > PS: SQlite starts to be kinda not the preferred way to store 10^5 records. > > > -- > > --- > 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/groups/opt_out. > > > -- --- 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/groups/opt_out.
