Re: [rt-users] slow join with cachedgroupmembers for a simple "comment" click

> 4 feb. 2016 kl. 02:11 skrev David Gwynne : > >> >> On 4 Feb 2016, at 10:21, Palle Girgensohn wrote: >> >> >> >> 4 feb. 2016 kl. 00:48 skrev David Gwynne : >> >>> On 4 Feb 2016, at 00:08, Palle Girgensohn

Re: [rt-users] slow join with cachedgroupmembers for a simple "comment" click

Hi David, Thanks for this input. it takes the query from 1 minute+ (== timeout in fcgid) to subseond. Big leap forward! Thanks! The two queries you posted are equally fast for me, ~ 8 ms, but render different result, 15 vs 16 rows. :-( Palle > 3 feb. 2016 kl. 13:39 skrev David Gwynne

Re: [rt-users] slow join with cachedgroupmembers for a simple "comment" click

> On 4 Feb 2016, at 00:08, Palle Girgensohn wrote: > > Hi David, > > Thanks for this input. > > it takes the query from 1 minute+ (== timeout in fcgid) to subseond. > > Big leap forward! > > Thanks! > > > The two queries you posted are equally fast for me, ~ 8 ms, but

Re: [rt-users] slow join with cachedgroupmembers for a simple "comment" click

> 4 feb. 2016 kl. 00:48 skrev David Gwynne : > > >> On 4 Feb 2016, at 00:08, Palle Girgensohn wrote: >> >> Hi David, >> >> Thanks for this input. >> >> it takes the query from 1 minute+ (== timeout in fcgid) to subseond. >> >> Big leap forward! >>

Re: [rt-users] slow join with cachedgroupmembers for a simple "comment" click

> On 4 Feb 2016, at 10:21, Palle Girgensohn wrote: > > > > 4 feb. 2016 kl. 00:48 skrev David Gwynne : > >> >>> On 4 Feb 2016, at 00:08, Palle Girgensohn wrote: >>> >>> Hi David, >>> >>> Thanks for this input. >>> >>> it takes

Re: [rt-users] slow join with cachedgroupmembers for a simple "comment" click

I'm not sure if your Owner dropdown is large, but this option might also help in a similar way by turning the Owner filed into a autocomplete so RT doesn't have to generate the full Owner dropdown on each page load where that field is offered: