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

2016-02-05 Thread Palle Girgensohn
> 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 wrote: Hi David, Thanks for this input. it ta

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

2016-02-03 Thread 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 wrote: >>> >>> Hi David, >>> >>> Thanks for this input. >>> >>> it takes the query from 1 minute+ (== timeout in fcgid) to subseond. >>

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

2016-02-03 Thread Palle Girgensohn
> 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! >> >> Thanks! >> >> >> The two queries you

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

2016-02-03 Thread 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! > > Thanks! > > > The two queries you posted are equally fast for me, ~ 8 ms, but render > different r

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

2016-02-03 Thread Jim Brandt
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: https://bestpractical.com/docs/rt/4.2/RT_Config.ht

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

2016-02-03 Thread Palle Girgensohn
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 : >