windskystar73
Programmer
I am building a search engine. but it is kind of complicated. i have a table that three columns, id, url, description. this is my sql.
select id, url from search where match(description) against ('oracle application server') limit 20
when i try this sql, it is really fast, but it doesn't return record set that contains these three words in order, 'oracle application server'. so i tried
match(description) against ('"oracle application server"' in boolean mode) limit 20, but it takes kind of long. and for description like '%oracle application server%', it takes forever.
I want to return record set that contains three words in order and then any words.
i am using Java to implement this. so i am just wondering if there is any better to solve this issue.
if anybody has a better idea, please let me know...
thanks...
select id, url from search where match(description) against ('oracle application server') limit 20
when i try this sql, it is really fast, but it doesn't return record set that contains these three words in order, 'oracle application server'. so i tried
match(description) against ('"oracle application server"' in boolean mode) limit 20, but it takes kind of long. and for description like '%oracle application server%', it takes forever.
I want to return record set that contains three words in order and then any words.
i am using Java to implement this. so i am just wondering if there is any better to solve this issue.
if anybody has a better idea, please let me know...
thanks...