Ah, well the real goal is for it to only be the number of statements pending in a given transaction.
So db.commit() or db.rollback() should clear the results... The time counting I am doing in my models, and in response._caller... but this is not including time taken to set up the environment before web2py executes the models. -Thadeus On Mon, Apr 5, 2010 at 2:43 PM, mdipierro <[email protected]> wrote: > But this does not count the time, just the number of past requests (in > thread? total?). Am I wrong? > Moreover the count will be wrong if the web server restarts the > process. no? > > Massimo > > On Apr 5, 2:33 pm, Thadeus Burgess <[email protected]> wrote: >> Novelty. Many websites you see will have at the bottom "time took to >> process request, number of queries to database". >> >> -Thadeus >> >> On Mon, Apr 5, 2010 at 2:24 PM, mdipierro <[email protected]> wrote: >> > I do not see any reason against except that I do not see any reason in >> > favor either. Why do you need it? >> >> > Massimo >> >> > On Apr 5, 2:16 pm, Thadeus Burgess <[email protected]> wrote: >> >> Attached is a patch to allow the dal.py to keep track of query counts and >> >> types. >> >> >> Usage >> >> >> >>> db.qry_count() >> >> >> {'SELECT': 5, 'INSERT': 2, 'DELETE': 1} >> >> >> Massimo, do you accept? >> >> >> -Thadeus >> >> >> qry_count.hg.diff >> >> 1KViewDownload >> >> > -- >> > You received this message because you are subscribed to the Google Groups >> > "web2py-users" group. >> > To post to this group, send email to [email protected]. >> > To unsubscribe from this group, send email to >> > [email protected]. >> > For more options, visit this group >> > athttp://groups.google.com/group/web2py?hl=en. > > -- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/web2py?hl=en. > > -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
