List:General Discussion« Previous MessageNext Message »
From:Rhino Date:September 22 2004 10:40pm
Subject:Re: help!!!!!!!!!!
View as plain text  
You're probably going to need to create some indexes on your tables. If you
have no indexes, MySQL can only do a full tablescan.

See the manual for the syntax of the statement that creates an index.

Rhino

----- Original Message ----- 
From: "Sven" <local.host@stripped>
To: <mysql@stripped>
Sent: Sunday, September 19, 2004 1:50 AM
Subject: help!!!!!!!!!!




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