Re: Mysql strategy
| From: | Dotan Cohen | Date: | Wed, 22 Nov 2006 11:50:49 +0000 |
| Subject: | Re: Mysql strategy | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-245028@lists.php.net to get a copy of this message | ||
On 21/11/06, Richard Lynch <ceo@l-i-e.com> 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/