Christoph Zwerschke wrote: > Janzert schrieb: > > I've attached my test project and scripts to the trac issue* if > > someone wants to double check my methods. > > I'm using the following add-on, maybe it's useful for you, too ;-) > https://addons.mozilla.org/en-US/thunderbird/addon/5759 >
Yeah, I probably would find that useful. But in this case I really did mean "I've attached ... to the trac issue*". With the url at the end of the message. :) * http://trac.turbogears.org/ticket/1879 >> As you can see the current method of iterating through the groups is >> actually 130 to 150 times faster than single query methods. > > I think this is because the current method uses the group.permissions > lists in the database session if possible. I.e. if you run it in a loop, > it will become very efficient. However, in reality this function will be > called only once or a few times per request, always in a fresh session. > You can simulate this with turbogears.database.session.expire_all(). > Doing so, I measured that the join method is about 3 times faster and > the exists method is about 2 times faster than the old method (similar > for both SQLite and Postgres 8.3). > Ah, yes some sort of caching going on would certainly make sense. I'll take another look at it. Janzert --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
