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 = '[email protected]'); 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
