Re: [rt-users] any page showing a user drop down in a ticket is loading slow

2013-12-18 Thread Adam Hobaugh
On 12/18/2013 11:43 AM, Kevin Falcone wrote: On Tue, Dec 17, 2013 at 02:53:53PM -0500, Adam Hobaugh wrote: I just updated from 4.0.10 to 4.2.1 and it seems to be working well except when I am in a ticket, any page that shows a user drop down, ie display and people load incredible slowly. I

Re: [rt-users] any page showing a user drop down in a ticket is loading slow

2013-12-18 Thread Adam Hobaugh
On 12/18/2013 01:07 PM, Kevin Falcone wrote: Your query here says that MySQL is looking at a pretty tiny dataset and running the same query on multiple databases here shows a wildly different explain and very quick results. This usually points to you having some enormous tables (although the

[rt-users] any page showing a user drop down in a ticket is loading slow

2013-12-17 Thread Adam Hobaugh
Hello, I just updated from 4.0.10 to 4.2.1 and it seems to be working well except when I am in a ticket, any page that shows a user drop down, ie display and people load incredible slowly. I enabled slow query logging and below are the two queries that appear to be causing the problem. I