Yes, you would use Oracle's intermedia engine ot ultrasearch. Builds a
special index for this type of thing.
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"Seth Brundle" <brundlefly76_at_hotmail.com> wrote in message
news:53e2ec95.0301190936.5ec88cc2_at_posting.google.com...
> I have created a 1.2M record database on MySQL, which has 3-4 text
> fields I need to do searches on - I need to match not only whole
> words, but *parts* of words, this is very important:
>
> select * from emails where subject LIKE "%keyword%" and from LIKE
> "%keyword%" and to LIKE "%keyword%"
>
> (ps the email table is just an example - its not what Im using it for)
>
> Anyways, I need to these queries to perform fast enough for a web
> page, but they take about 90 seconds. Unfortunately, MySQL cannot use
> any type of index to help with searching for terms which have
> wildcards on both sides of the term.
>
> (closest it comes is the match...against, which allows wildcard on the
> right-hand side only)
>
> Anyways, I was wondering if Oracle Linux would be the solution to my
> problem - can it index this type of query? Could I expect <5s quereies
> on a 1GB 1.7Ghz machine?
Received on Sun Jan 19 2003 - 11:45:56 CST
