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:

[rt-users] Fully Removing Queues, Users, Etc...

--- Begin Message --- First a little background. We have 2 companies using the same RT instance, each with access to a different set of queues.. This worked well for multiple years. Now for non technical reasons () we need to separate one of the companies out. So they can import their

[rt-users] Send Mail to RT from PHP Form

Hi There, I've created on my web site a form to get some information from my customers and send this by mail. I've received the email's and the ticket get created in the right queue except that the custom field value I pass. If I send by Outlook as a plan text mail, its works well and the