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
