I would like to hear what others think as well.
I do not see how the DAL class knows, could know, might know, when a
query is being executed?
-Thadeus
On Mon, Apr 5, 2010 at 3:15 PM, mdipierro <mdipie...@cs.depaul.edu> wrote:
> Since the new DAL is a class you can define them by subclassing DAL.
> What do you think? I am not convinced this is useful in general and
> needs to be in trunk. It seems a very specialized application but
> perhaps I am missing something. I'd like to hear what other people
> think about this.
>
> On Apr 5, 3:00 pm, Thadeus Burgess <thade...@thadeusb.com> wrote:
>> 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
>> > 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.
