[rt-users] What is searchbuilder

[Micah Gersten]

The main problem is searching through the RT interface is slow.  The DB
lookups seem to be fine.

Thank you,
Micah Gersten
onShore Networks
http://www.onshore.com
 

-----Original Message-----
From: Kenneth Crocker [mailto:KFCrocker at lbl.gov] 
Sent: Tuesday, October 30, 2007 2:10 PM
To: Micah Gersten
Cc: 'Roy El-Hames'; rt-users at lists.bestpractical.com
Subject: Re: [rt-users] What is searchbuilder

Micah,


	Actually, there are several ways to speed up searches without trying
to 
fool around with searchbuilder. It works fine for us. If we have a 
search/query that takes too long, we look at any of the following:

      1) Does the SQL create any inefficient joins or links?
      2) How is the DB set up? Are there ways to speed up the DB access 
using different pathways, etc.
      3) Does the query look for data in a list/sequential fashion or 
does it use existing keys/indexes?
      4) Does the DB table need additional indexes?

	Also, depending on the search, if you have too many privileges that
are 
global in nature, that could also increase search time. You just have to 
evaluate the way you write queries with an experienced eye. Hope this helps.


Kenn
LBNL

On 10/29/2007 9:09 AM, Micah Gersten wrote:
> I think it's a built in component, but I would like to know if there is a
> way to tweak it to make searches faster.
> 
> Thank you,
> Micah Gersten
> onShore Networks
> http://www.onshore.com
>  
> 
> -----Original Message-----
> From: Roy El-Hames [mailto:rfh at pipex.net] 
> Sent: Monday, October 29, 2007 11:07 AM
> To: Micah Gersten
> Cc: rt-users at lists.bestpractical.com
> Subject: Re: [rt-users] What is searchbuilder
> 
> Can you use RT without it ???
> 
> Roy
> 
> Micah Gersten wrote:
>> My company is running an RT installation v. 3.6.0.
>>
>>  
>>
>> What is searchbuilder?  Can we use it to speed up RT searches?
>>
>>  
>>
>> Thank you,
>>
>> Micah Gersten
>>
>> onShore Networks
>>
>>
>>   
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>
>> SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:
>>
>> If you sign up for a new RT support contract before December 31, we'll
> take
>> up to 20 percent off the price. This sale won't last long, so get in
touch
> today. 
>>     Email us at sales at bestpractical.com or call us at +1 617 812 0745.
>>
>>
>> Community help: http://wiki.bestpractical.com
>> Commercial support: sales at bestpractical.com
>>
>>
>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
>> Buy a copy at http://rtbook.bestpractical.com
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:
> 
> If you sign up for a new RT support contract before December 31, we'll
take
> up to 20 percent off the price. This sale won't last long, so get in touch
today. 
>     Email us at sales at bestpractical.com or call us at +1 617 812 0745.
> 
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
>