<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Jesse.<br>
<br>
<br>
Jesse Vincent wrote:
<blockquote cite="mid20051031040035.GT14262@bestpractical.com"
type="cite">
<pre wrap="">Try installing Clone from CPAN?
</pre>
</blockquote>
Duh, What's with my brain today?<br>
<br>
Guess what.<br>
An absolute improvement :-)<br>
The query is now loading in normal time, yiha!<br>
<br>
Thanks for your help,<br>
Kind regards.<br>
Luke.<br>
<br>
<blockquote cite="mid20051031040035.GT14262@bestpractical.com"
type="cite">
<pre wrap="">
On Mon, Oct 31, 2005 at 02:29:12PM +1030, Luke Vanderfluit wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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:
</pre>
<blockquote type="cite">
<pre wrap="">in dbix::searchbuilder
Best,
Jesse
-----Original Message-----
From: Luke Vanderfluit <a class="moz-txt-link-rfc2396E" href="mailto:lvanderf@internode.com.au"><lvanderf@internode.com.au></a>
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.
<a class="moz-txt-link-freetext" href="http://rt3.fsck.com/Ticket/Display.html?id=6624">http://rt3.fsck.com/Ticket/Display.html?id=6624</a> 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.
</pre>
</blockquote>
<pre wrap="">
--
Luke
</pre>
</blockquote>
<pre wrap=""><!---->
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Luke
</pre>
</body>
</html>