Re: Problem in Fulltext Search

2005-08-05 Thread Gleb Paharenko
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

Re: Problem in Fulltext Search

2005-08-05 Thread SGreen
"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. > >

Problem in Fulltext Search

2005-08-05 Thread Suryya Ghosh
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