The key to speed with SQL databases is INDEX. You are doing sequential
reads of the contents of each of these fields; no matter what database you
used performance would be atrocious.
Can you break some keywords out of your text, and assign them to fields
like keywd1, keywd2, etc.?
How often
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 sett
2 matches
Mail list logo
