[rt-users] UseSQLForACLChecks performance problem on RT 3.8

2013-01-31 Thread k...@rice.edu
Dear RT community, While investigating performance issues caused by enabling the option UseSQLForACLChecks, a big cause of the slowdown was drawing the QuickSeach panel and its resulting DB queries. In RT4 they have been consolidated into a single query. I have attached a patched version of

Re: [rt-users] UseSQLForACLChecks performance problem on RT 3.8

2013-01-31 Thread Ruslan Zakirov
On Thu, Jan 31, 2013 at 8:45 PM, k...@rice.edu k...@rice.edu wrote: Dear RT community, While investigating performance issues caused by enabling the option UseSQLForACLChecks, a big cause of the slowdown was drawing the QuickSeach panel and its resulting DB queries. In RT4 they have been

Re: [rt-users] UseSQLForACLChecks performance problem on RT 3.8

2013-01-31 Thread k...@rice.edu
On Thu, Jan 31, 2013 at 09:02:59PM +0400, Ruslan Zakirov wrote: On Thu, Jan 31, 2013 at 8:45 PM, k...@rice.edu k...@rice.edu wrote: Dear RT community, While investigating performance issues caused by enabling the option UseSQLForACLChecks, a big cause of the slowdown was drawing the

Re: [rt-users] UseSQLForACLChecks performance problem on RT 3.8

2013-01-31 Thread Ruslan Zakirov
On Thu, Jan 31, 2013 at 10:24 PM, k...@rice.edu k...@rice.edu wrote: On Thu, Jan 31, 2013 at 09:02:59PM +0400, Ruslan Zakirov wrote: On Thu, Jan 31, 2013 at 8:45 PM, k...@rice.edu k...@rice.edu wrote: Dear RT community, While investigating performance issues caused by enabling the option

Re: [rt-users] UseSQLForACLChecks performance problem on RT 3.8

2013-01-31 Thread k...@rice.edu
On Fri, Feb 01, 2013 at 03:28:35AM +0400, Ruslan Zakirov wrote: On Thu, Jan 31, 2013 at 10:24 PM, k...@rice.edu k...@rice.edu wrote: On Thu, Jan 31, 2013 at 09:02:59PM +0400, Ruslan Zakirov wrote: On Thu, Jan 31, 2013 at 8:45 PM, k...@rice.edu k...@rice.edu wrote: Dear RT community,