Hello
> We use MySQL 3.23.32, so I recently added a FULLTEXT index for this
> field on all forums and changed the source code to make use of the
> MATCH() AGAINST() MySQL call.
If you make FULLTEXT queries over many tables, and combine the results
afterwards, you might get into problems with 3.2
nal Message -
From: "Noor Dawod" <[EMAIL PROTECTED]>
To: "Jason Terry" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, February 13, 2001 9:23 AM
Subject: RE: TEXT's are giving us headaches!
> Hi
>
> Hmm, this seems to me like redundant
rom: Jason Terry [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 13, 2001 6:07 PM
To: Noor Dawod
Cc: [EMAIL PROTECTED]
Subject: Re: TEXT's are giving us headaches!
A mistake I made for a long time with MATCH AGAINST is to not include it
in the WHERE clause
eg I did
SELECT ID,MATCH Q,A
e latter will give much better performance
- Original Message -
From: "Noor Dawod" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Tuesday, February 13, 2001 7:51 AM
Subject: TEXT's are giving us headaches!
> Hello,
>
> We operate
Hello,
We operate a forums website and use Phorum web application (PHP/MySQL
backend), more info: http://www.phorum.org
After operating for two years now, we are facing a serious problem.
Giving the fact that the forums are full of content, ONE (1) search
operation on a single forum is draining
