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:[EMAIL PROTECTED]
Sent: Monday, October 29, 2007 11:07 AM
To: Micah Gersten
Cc: [email protected]
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 [EMAIL PROTECTED] or call us at +1 617 812 0745.
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
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 [EMAIL PROTECTED] or call us at +1 617 812 0745.
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
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 [EMAIL PROTECTED] or call us at +1 617 812 0745.
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
