[rt-users] Huge Attachments table in 3.4.4

[Jesse Vincent]

Try installing Clone from CPAN?



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
> 

--