Thanks for reply! At first glance most of the problem could be fixed by passing correct limit and offset parameters from paginator all the way down to provider.query(), I was surprised the support seems to be there but parameters are not passed. I don't have time right now to dig deeper, must finish and ship the site soon. Fortunately tgext.admin was planned only for backend usage and can be avoided/fixed later.
Juraj Dňa štvrtok, 6. septembra 2012 15:31:33 UTC+2 Alessandro Molina napísal(-a): > > Currently tgext.admin has not been optimized at all for performances > and as you noticed it retrieves every related object instantly. > I tend never to use it with more than a few hundred records, when I > need to manage big collections I tend to write custom get_all methods. > > There is for sure an huge space for optimizations in sprox on that > topic right now. > I'll try to give a look as soon as possible but I cannot guarantee you > to roll out a new release in a short time as that is a part of sprox > that I didn't write myself. > > On Thu, Sep 6, 2012 at 12:01 PM, Juraj Variny <[email protected]<javascript:>> > wrote: > > Hi, > > > > does here anybody actually use admin extension with meaningful amounts > of > > data? When I started having 1000+ records in test database, just listing > > them took several seconds. I have looked with debugger what it is doing > and > > it seems that: > > > > * Regardless of paging, all records in the table are fetched and for > every > > one record extra select query is done > > * If there is one-to many relationship, also all records from related > table > > are fetched and for every one record extra select query is done > > > > Or tgext.admin is meant to be this way and I have it badly configured? > This > > happened both with sqlite and postgres. > > > > -- > > You received this message because you are subscribed to the Google > Groups > > "TurboGears" group. > > To view this discussion on the web visit > > https://groups.google.com/d/msg/turbogears/-/hGZLwVYcVDEJ. > > To post to this group, send email to > > [email protected]<javascript:>. > > > To unsubscribe from this group, send email to > > [email protected] <javascript:>. > > For more options, visit this group at > > http://groups.google.com/group/turbogears?hl=en. > -- You received this message because you are subscribed to the Google Groups "TurboGears" group. To view this discussion on the web visit https://groups.google.com/d/msg/turbogears/-/i4Tr_veGbfEJ. 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.
