[rt-users] Huge Attachments table in 3.4.4

[Luke Vanderfluit]

Hi Jesse.


Jesse Vincent wrote:

>Try installing Clone from CPAN?
>
>  
>
Duh, What's with my brain today?

Guess what.
An absolute improvement :-)
The query is now loading in normal time, yiha!

Thanks for your help,
Kind regards.
Luke.

>On Mon, Oct 31, 2005 at 02:29:12PM +1030, Luke Vanderfluit wrote:
>  
>
>>Hi Jesse.
>>
>>I have entered the modification into the SearchBuilder.pm file
>>Then recompile the DBIx::SearchBuilder package.
>>
>>Now I get a message that Clone.pm can't be located in the @INC
>>
>>And the install of DBIx::SearchBuilder fails.
>>
>>If I install that module without the modification, then try to reload 
>>RT, it complains as well :-(
>>
>>I think the first way is the way but how do I fix the problem that it 
>>can't find Clone.pm.
>>
>>Thanks.
>>Kind regards.
>>Luke.
>>
>>
>>
>>Jesse Vincent wrote:
>>
>>    
>>
>>>in dbix::searchbuilder
>>>Best,
>>>Jesse
>>>
>>>-----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
>>
>>    
>>
>
>  
>


-- 
Luke

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20051031/d044e1b4/attachment.htm>