Hello.
The common solution for similar issues which appeared on the
list not recently was modifying the query to use UNIONs. For
example:
select field1, field2
from tblMerge
where
MATCH(field1)
AGAINST('food' IN BOOLEAN MODE)
Or
MATCH(field1)
AGAINST('locomotive' IN BOOLEAN MO
"Suryya Ghosh" <[EMAIL PROTECTED]> wrote on 08/05/2005 09:50:27
AM:
> Hi,
>
> We have a table containing more than 15 million rows of data, can
> anybody please help in this problem of fulltext search described below.
>
> The following query is giving a good result in terms of query time.
>
>
Hi,
We have a table containing more than 15 million rows of data, can anybody
please help in this problem of fulltext search described below.
The following query is giving a good result in terms of query time.
select field1, field2
from tblMerge
where
MATCH(field1)
AGAINST('food' IN BOOLEAN M