Re: [PHP] Mysql strategy

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/
.

Relevant Pages

  • Mysql strategy
    ... If I have to perform 30 LIKE searches for different keywords in a ... To select the varchar field from all the rows, ... and the machine is a dedicated server running RHEL. ... Thanks in advance for any advice. ...
    (php.general)
  • Searching for misspelled keywords?
    ... I'm using SQL queries with LIKE operator to search for keywordin a ... VARCHAR field of a table. ... for alternate spellings incase of any misspellings, ... Please note that I need to search for one or more keywords in VARCHAR fields ...
    (microsoft.public.sqlserver.programming)
  • Re: Adding command to a text file to make a sql statement?
    ... upload it to Mysql. ... Assuming that's a tab character between the ID and the keywords: ... The newline character doesn't work as expected. ...
    (comp.unix.shell)
  • Re: [PHP] Mysql strategy
    ... On 13/11/06, Chris wrote: ... > If I have to perform 30 LIKE searches for different keywords in a ... > 2) To select the varchar field from all the rows, ... This is the makeLink function in another ...
    (php.general)
  • Re: [PHP] Mysql strategy
    ... > If I have to perform 30 LIKE searches for different keywords in a ... > 2) To select the varchar field from all the rows, ... If you are worried about the speed of this query I'd suggest rethinking ... your database structure. ...
    (php.general)