I found the reason. It was because of my own caching mechanism, which
prevented executesql from executing. Thanks for help!
W dniu poniedziałek, 24 marca 2014 18:45:59 UTC+1 użytkownik Massimo Di
Pierro napisał:
>
> Please submit a bug report. It is possible executesql does not log it.
>
> On Monday, 24 March 2014 08:11:56 UTC-5, Maciej S wrote:
>>
>> Hello
>>
>> I try to use response.toolbar() to measure database queries. I've added
>> it to the site, now it shows statistics only for tables created by web2py
>> auth and tables connected to them, for example:
>>
>> SET standard_conforming_strings=on;
>>
>> 0.14ms
>>
>> SELECT company.id, company.number, company.name FROM company;
>>
>> 0.43ms
>>
>> SELECT count(*) FROM auth_group WHERE (auth_group.role = 'root');
>>
>> 0.72ms
>>
>> SELECT count(*) FROM auth_group WHERE (auth_group.role = 'service');
>>
>> 0.11ms
>>
>> SELECT count(*) FROM auth_group WHERE (auth_group.role = 'producer');
>>
>> 0.10ms
>>
>> SELECT count(*) FROM auth_user WHERE (auth_user.email = 'te...@test.com');
>>
>> 0.20ms
>>
>> SELECT auth_group.id, auth_group.role, auth_group.description FROM
>> auth_group WHERE (auth_group.role = 'service');
>>
>> 0.20ms
>>
>> SELECT auth_membership.id, auth_membership.user_id,
>> auth_membership.group_id FROM auth_membership WHERE
>> ((auth_membership.user_id = 1) AND (auth_membership.group_id = 2));
>>
>> 0.31ms
>>
>> I have another tables like:
>>
>> db.define_table('controller',
>> Field('uid', 'string', length=64, unique=True),
>> Field('descr', 'string', length=256, notnull=True),
>> Field('address_id', db.address, ondelete='SET NULL'),
>> Field('service_access', 'boolean', notnull=True))
>>
>> There is db.executesql query for that table and statistics are not shown.
>> Do you known what is the reason for that?
>>
>> Maciej S
>>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
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/d/optout.
