I guess this is an answer to my problem: http://turbogears.org/2.1/docs/main/Deployment/OptimizingTWResources.html
On Jul 8, 4:46 pm, qba <[email protected]> wrote: > 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.
