Speed issue when restrict_owner=true

[olivermn@…]

I am using Trac-0.11stable_r7825-py2.3.egg.

Historically I have advised our new users to fill in Preferences so that email addresses would be available to all in the ticket pull-downs. That coupled with restrict_owner=true has allowed us manage email addresses and limited typos from those inputting tickets.

However, it has also made our ticket tracking slower and slower as users have been added. Now with about 50 users, opening a ticket can take @55sec (unacceptable). A discovery was made that if you removed table entries from the SQL table, sessions, that performance was greatly improved. Eventually this led to our changing of trac.ini to use restrict_owner=false.

I have searched through the tickets and not found a good match. In #7678 a recommendation was made to turn off restrict_owner but there has been no response in the past 4 months and the issue there was over other inefficencies.

I'm using Trac 0.11stable-r7825 which I think should include #6436 and [7610].

Ideally, I'd like to re-enable restrict_owner to true.

---

I appreciate your help. The world won't come to an end without this one. But performance always sours folks on a tools use.

[Remy Blank]

Could you please give us the number of rows in your session and session_attribute tables?

select count(*) from session;
select count(*) from session_attribute;

[anonymous]

Here is the output from sql:

sqlite> select count(*) from session;
72
sqlite> select count(*) from session_attribute;
274

[datallah@…]

If you're not using complicated permissions, you may find that the "UsersWithPermCachingPermissionStore" plugin that we use for the Pidgin trac ([here ​http://developer.pidgin.im/wiki/LocalTracChanges]) meets your needs.

[anonymous]

Our setup still uses fine-grained permissions. I have a duplicate test system which I can try to make the change to just to see how it works for me. Thanks

[Christian Boos]

#8212 reported extreme slowdown due to restrict_owner = true:

The setting for restrict_owner in the trac.ini was set to true which caused either opening new tickets or displaying existing tickets to take from 5-25 seconds to display. Setting this vaule to false reduced the display time to ~1 sec for both. (comment 3)

Now there has been a previous attempt to improve the speed of get_users_with_permissions, attempt which failed and has been reverted in r5849 with admittedly inefficient code… This lead me to the original ticket #4245, which was actually reopened.

So I'm now closing this one as duplicate of #4245.