On 11/28/07, Alec Thomas <[EMAIL PROTECTED]> wrote: > On 11/28/07, Alec Thomas <[EMAIL PROTECTED]> wrote: > > > > This is the area that we can improve. Try the attached patch, it caches > > the results of get_user_permissions() for up to 5 seconds, which should > > massively reduce the number of hits on the database. > > Slightly cleaner patch attached.
Testing with an old sqlite copy of the Trac database, I see the following results: Before the patch: Permission checks on 2702 tickets took 1.29666638374 seconds After the patch: Permission checks on 2702 tickets took 0.19308590889 seconds -- Evolution: Taking care of those too stupid to take care of themselves. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Development" 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/trac-dev?hl=en -~----------~----~----~----~------~----~------~--~---
