Speed issue when restrict_owner=true
|Reported by:||Owned by:|
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.
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.