Ryan:
If your response time for this query is slow, it is likely that an INDEX
will help
you. (Read about CREATE INDEX in the MySQL manual.
If you don't already have an INDEX on the keyWord column, create one.
If you can induce your customer/users to type more characters, that
would help.
WHERE keyWord LIKE 'salomi%' is much better for you than
WHERE keyWord LIKE 's%' .
NOTE, that if your response time to this query is good, there could be
something
other than MySQL running on your machine that is sucking your CPU dry.
You might be able to spot it by running 'top' 'ps -ef' or whatever
command is
available for your machine.
Cheers,
Kent Hoover
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
