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
> <javascript:>');
>
> 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.
