[rt-users] Huge Attachments table in 3.4.4

[Luke Vanderfluit]

Hi.

Jesse Vincent wrote:

>in dbix::searchbuilder
>  
>
Thanks,
I'll let you know if it helped :-)

Kind regards.
Luke.

>-----Original Message-----
>From: Luke Vanderfluit <lvanderf at internode.com.au>
>Date: Sunday, Oct 30, 2005 9:02 pm
>Subject: Re: [rt-users] Huge Attachments table in 3.4.4
>
>Hi.
>
>
>
>
>
>Jesse Vincent wrote:
>    Luke,
>
>Are you up for trying the patch we've been testing for this? If so, please see attached
>
>    
>I've added the patches from the rights.patch file to the appropriate files. That's fine.
>
>However I can't find the right location in the SearchBuilder.pm file to insert the code from the clone.patch file.
>
>
>
>I'm using 3.4.4, where do I insert the code from the clone.patch file?
>
>
>
>Thanks.
>
>Kind regards.
>
>Luke.
>
>     On Fri, Oct 28, 2005 at 04:41:05PM +0930, Luke Vanderfluit wrote:
>          Hi.
>
>Ok. I'm now at the point where:
>-(I'm about to fetch the axe from the shed :-)
>-I've removed all indexes from the Groups table
>-created the following indexes:
>
>create unique index groups_key on Groups(id);
>create index Groups1 ON Groups (Domain, Instance, Type, id);
>create index Groups2 ON Groups (Type, Instance, Domain);
>
>Then I did a trial run: 138 seconds to complete the query
>
>I created 2 more indexes
>
>create index Groups3 on Groups(Instance);
>create index Groups4 on Groups(Type);
>
>Another trial run: 137 seconds.
>
>I created the following index:
>create index Groups5 on Groups(Domain);
>
>144 seconds.
>
>The query in question is the same as on the following site and the 
>indexes are taken from that site.
> http://rt3.fsck.com/Ticket/Display.html?id=6624 after dropping the last index I added (it seemed to only worsen the pain) I stopped and started both mysql and apache
>then got 150 seconds.
>hmmm.....
>
>So these particular indexes didn't help.
>
>I've used the expain select syntax to show what keys are being used in 
>the query, it show that I have *no* keys being used on the Users table. 
>I've tried several keys on the Users table but with no success.
>I've documented everything so can supply you with the indexes if interested.
>
>
>I'm sure there is an index out there that does what I want,
>Any suggestions/help appreciated.
>
>Thanks.
>Kind regards.
>Luke.
>
>  
>


-- 
Luke