Disable fulltext search on simple search

Hi all,

I have a question regarding de fulltext search option on the simple
search page. Is it possible to disable this feature there? The idea
behind this is that I don’t want a regular user searching the database
like that. Currently if we do a fulltext search the RT server becomes
noticeable slower. Since the database will only grow the time required
to do this will increase affecting other users for a longer period of
time. We try to use the subject field and custom fields to contain
usefull information to search for more quickly.

I know you can’t disable fulltext search in general, I just want to make
less obvious for the regular user to use it.

Regards,

Ton Hoogstraten

It can be pretty frustrating for users to have trouble locating
a ticket easily with searches. I can see disabling full-text
body searching, but not the simple search fields. The best solution
is to use a DB with full-text indexing support. Currently, the wiki
has a patch for Oracle and we will be submiting a similar patch for
use with PostgreSQL 8.3 and later. Then you get your cake and can
eat it too. :slight_smile:

Cheers,
KenOn Thu, Sep 11, 2008 at 05:16:38PM +0200, Hoogstraten, Ton wrote:

Hi all,

I have a question regarding de fulltext search option on the simple
search page. Is it possible to disable this feature there? The idea
behind this is that I don’t want a regular user searching the database
like that. Currently if we do a fulltext search the RT server becomes
noticeable slower. Since the database will only grow the time required
to do this will increase affecting other users for a longer period of
time. We try to use the subject field and custom fields to contain
usefull information to search for more quickly.

I know you can’t disable fulltext search in general, I just want to make
less obvious for the regular user to use it.

Regards,

Ton Hoogstraten


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Here is another vote for that patch!On Sep 11, 2008, at 4:32 PM, Kenneth Marshall wrote:

Currently, the wiki
has a patch for Oracle and we will be submiting a similar patch for
use with PostgreSQL 8.3 and later.

Paulo F. Andrade
pauloandrade@ist.utl.pt