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
Can you use RT without it ???
Roy
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.comFrom: Roy El-Hames [mailto:rfh@pipex.net]
Sent: Monday, October 29, 2007 11:07 AM
To: Micah Gersten
Cc: rt-users@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
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@bestpractical.com or call us at +1 617 812 0745.Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.comDiscover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
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
LBNLOn 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@pipex.net]
Sent: Monday, October 29, 2007 11:07 AM
To: Micah Gersten
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] What is searchbuilderCan 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
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@bestpractical.com or call us at +1 617 812 0745.Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.comDiscover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
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@bestpractical.com or call us at +1 617 812 0745.Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.comDiscover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
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.comFrom: Kenneth Crocker [mailto:KFCrocker@lbl.gov]
Sent: Tuesday, October 30, 2007 2:10 PM
To: Micah Gersten
Cc: ‘Roy El-Hames’; rt-users@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
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@pipex.net]
Sent: Monday, October 29, 2007 11:07 AM
To: Micah Gersten
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] What is searchbuilderCan 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
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@bestpractical.com or call us at +1 617 812 0745.Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.comDiscover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
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@bestpractical.com or call us at +1 617 812 0745.Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.comDiscover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com