[rt-devel] Slow Queries part3, Groups

[Matthew Watson]

Anyone had any luck with this (I admin its dropped off my radar for a few
days, but its back now)?

Regards,
Matt Watson.


> Hey, I'm not done yet.
>
> I've been reading the nitty-gritty parts of the MySQL documentation.
>
> When I run the aforementioned query against my database (20k tickets,
> 10,000 users), it takes about a second.  That's not great, but when
> the cache kicks in, it drops down to half a second.  That's still not
> great.