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 <mdipie...@cs.depaul.edu> 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 <thade...@thadeusb.com> 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 <mdipie...@cs.depaul.edu> 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 <thade...@thadeusb.com> 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 web...@googlegroups.com.
>> > To unsubscribe from this group, send email to 
>> > web2py+unsubscr...@googlegroups.com.
>> > 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 web...@googlegroups.com.
> To unsubscribe from this group, send email to 
> web2py+unsubscr...@googlegroups.com.
> 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 web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.

Reply via email to