Re: Problem with performance!
On our system,
SELECT * FROM tablex WHERE field1 MATCHES '[K,k][O,o][P,p]*'took 45 seconds to run
when I changed it to
SELECT * FROM tablex WHERE field1 MATCHES 'K[O,o][P,p]*'
union
SELECT * FROM tablex WHERE field1 MATCHES 'k[O,o][P,p]*'
it took 1 second...
On Thu, 19 Mar 1998 14:58:11 +0100, marko kopac <marko.kopac@mais.si>
wrote:
>Hello!
>
>Could anybody help me!!!
>
>How to make my SQL quicker: SELECT * FROM tablex WHERE field1 MATCHES
>'[K,k][O,o][P,p]*'
>
>Index is made by field1, table contains 34500 records, sql working 30
>seconds. Is that normal?
>
>
>Marko
>