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]
