On 21/11/06, Richard Lynch <[EMAIL PROTECTED]> wrote:
On Sun, November 12, 2006 6:02 pm, Dotan Cohen wrote:
> If I have to perform 30 LIKE searches for different keywords in a
> varchar field, which strategy would be recommended:
> 1) 30 searches, one for each keyword
> 2) To select the varchar field from all the rows, and search through
> them with php's array functions?
>
> There are about 500 rows in the table, and growing. The mysql server
> is on localhost, and the machine is a dedicated server running RHEL.
> It's not my machine, so I'd like to be responsible with resources, as
> much as I can be. Thanks in advance for any advice.
I think what you have done is very similar to the "full text index"
solution of MySQL, only yours is a lot slower...
You may want to re-read about MySQL full text index:
http://mysql.com/
Thanks, Richard. I'm looking into the full text index again.
Dotan Cohen
http://dotancohen.com/
http://lyricslist.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
