[ic] very slow (20 seconds) form search (MV.4.6.3)

[sda sda]

--- Mike Heins <mikeh@minivend.com> wrote:
> Quoting sda sda (cafedvd@yahoo.com):
> > When I used the following form search,
> > 
> > <FORM ACTION="[area search]">
> > <INPUT TYPE=hidden NAME=mv_searchtype VALUE=sql>
> > <select name="mv_search_field">
> > <option value="title" selected> Titles
> > <option value="actor">Cast</select>
> > <INPUT MAXLENGTH=30 NAME=mv_searchspec type=text
> > size=10>
> > <INPUT TYPE=hidden NAME=mv_column_op VALUE=rm>
> > 
> > 
> > 
> > the response time is almost 20 seconds using
> mysql.
> > When I checked the log file in mysql,
> > I noticed that it had  'SELECT * FROM products'
> > line that is responsible for the delay.
> > Why is minivend generating this sql command?
> > Is this a bug? Or, is there another way to
> > search using form inputs?
> > 
> > I have 36000 items in products.
> 
> How is it supposed to do a full-text search without
> looking at every
> record, pray tell?

Shouldn't the query contain 'WHERE' clause such as:

  SELECT * FROM products WHERE title LIKE "%foo%"

instesd of the time consuming query below?

  SELECT * FROM products









__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/