Speeding up MySQL querys
| From: | Jome | Date: | Mon, 23 Jul 2001 13:56:06 +0000 |
| Subject: | Speeding up MySQL querys | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-59198@lists.php.net to get a copy of this message | ||
Hello,
for the moment I'm trying to write searchengine kind-of-thing in PHP using MySQL, however MySQL
tend to be very slow when searching.
My table is about 100 mb and the query is SELECT * FROM search WHERE search.content LIKE
'%$keyword%' OR search.filnamn LIKE '%$keyword%'
I've tried setting INDEX but it didn't work out since I'm using BLOB-fields. Is there
any other way than using INDEX?
Thanks,
Jome