Hi,
I finally managed to get tw.dojo grid running with tgext.admin but it
made the whole thing impossibly slow.
The reason seems to be permission query being executed many times.
Something like:
----------------------------------------------------------------------------------------------------------------------------------------
15:29:47,796 INFO [sqlalchemy.engine.base.Engine.0x...1670] SELECT
tg_permissio
n.permission_id AS tg_permission_permission_id,
tg_permission.permission_name AS
tg_permission_permission_name, tg_permission.description AS
tg_permission_descr
iption
FROM tg_permission, tg_group_permission
WHERE %(param_1)s = tg_group_permission.group_id AND
tg_permission.permission_id
= tg_group_permission.permission_id
15:29:47,796 INFO [sqlalchemy.engine.base.Engine.0x...1670]
{'param_1': 1}
----------------------------------------------------------------------------------------------------------------------------------------
gets executed around 50 times, to display 2 records in the grid. Than
everything works fine, it just takes ages to do so.
There is no problem when using standard tgext.crud without tw.dojo.
Can anybody help?
Thanks,
qba
--
You received this message because you are subscribed to the Google Groups
"TurboGears" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/turbogears?hl=en.
