List:General Discussion« Previous MessageNext Message »
From:Eric Bergen Date:September 22 2004 10:19pm
Subject:Re: help!!!!!!!!!!
View as plain text  
Sven,
  This warning is telling you there your query is going to execute
very slowly. The EXPLAIN that it talks about is mentioned in the
manual here:
http://dev.mysql.com/doc/mysql/en/EXPLAIN.html

You should also search the manual for sections on query optimization
and index usage.

Here is another document that will help you get help online easier. 
http://www.catb.org/~esr/faqs/smart-questions.html

-- 
Eric Bergen
eric.bergen@stripped


On Sun, 19 Sep 2004 07:50:14 +0200, Sven <local.host@stripped> wrote:
> 
> 
> Warning: mysql_query() [http://www.mysql.com/doc]: Your query requires a full
> tablescan (table bb1_designelements, 78 rows affected). Use EXPLAIN to optimize your
> query.
> 
> I get this error on every products i tested
>
Thread
help!!!!!!!!!!Sven22 Sep
  • Re: help!!!!!!!!!!Eric Bergen23 Sep
  • Re: help!!!!!!!!!!Rhino23 Sep