On your two word plus searches, `New York` for example, have you tried using
`IN BOOLEAN MODE` to reduce the number of false positives?
AGAINST("New York" IN BOOLEAN MODE)
-----Original Message-----
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 8/12/04 8:33 AM
Subject: RE: Fulltext Search takes 17 sec.
Hi Victor,
The fulltext index was created on 1 column only that is of type
"text".
The benchmarks I get are very inconsistant...
SELECT product_id FROM product_fulltext WHERE MATCH ( search_text )
AGAINST ('China')
>Query took 20.17 seconds
SELECT product_id FROM product_fulltext WHERE MATCH ( search_text )
AGAINST ('Mongolia')
>Query took 0.43 seconds
SELECT product_id FROM product_fulltext WHERE MATCH ( search_text )
AGAINST ('russia')
>Query took 6.18 seconds
SELECT product_id FROM product_fulltext WHERE MATCH ( search_text )
AGAINST ('United States')
>Query took 35.57 seconds
SELECT product_id FROM product_fulltext WHERE MATCH ( search_text )
AGAINST ('Chicago')
>Query took 11.81 seconds
SELECT product_id FROM product_fulltext WHERE MATCH ( search_text )
AGAINST ('New York')
>Query took 43.14 seconds
SELECT product_id FROM product_fulltext WHERE MATCH ( search_text )
AGAINST ('heserfretzel')
>Query took 0.04 seconds
The last word I made up. It seems to be directly proportional to the
number of results it pulls up.
:(
- John
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
