Ok, I figured out permission check is performed due to javascript files loaded by the grid. (for each file)
Files are loaded from: http://127.0.0.1/toscawidgets/resources/tw.dojo/.... Can I configure repoze to treat them as static files, and skip permission check? Thanks On Jul 8, 3:41 pm, qba <[email protected]> wrote: > 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.
