Re: [rt-users] Disable fulltext search on simple search

2008-09-17 Thread Paulo Filipe Andrade
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
[EMAIL PROTECTED]




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

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


[rt-users] Disable fulltext search on simple search

2008-09-11 Thread Hoogstraten, Ton
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: [EMAIL PROTECTED]


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

Re: [rt-users] Disable fulltext search on simple search

2008-09-11 Thread Kenneth Marshall
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.  :)

Cheers,
Ken

On 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: [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

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