On 21/11/06, Richard Lynch <ceo@xxxxxxxxx> 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