[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
[ic] very slow (20 seconds) form search (MV.4.6.3)
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.
Help!
Thanks in advance.
Steve
__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
_______________________________________________
Interchange-users mailing list
Interchange-users@lists.akopia.com
http://lists.akopia.com/mailman/listinfo/interchange-users
