hello,
i was wondering if anyone could help me to optimize a query i use when
gathering search results? this is easily the most complicated query i've
written (and likely a walk in the park for most of you) and because of
this, i'm afraid it's a bit slow.
SELECT COUNT(p.id)
FROM products AS
You set up your situation very well but for one small item. Please allow
me to kindly introduce you to the EXPLAIN command
http://dev.mysql.com/doc/mysql/en/EXPLAIN.html
Post the results from using that on your query and we will be good to go
:-)
Shawn Green
Database Administrator
Unimin
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
on Thursday, October 07, 2004 12:30 PM said:
You set up your situation very well but for one small item. Please
allow me to kindly introduce you to the EXPLAIN command
http://dev.mysql.com/doc/mysql/en/EXPLAIN.html
hey! that looks like it
Can you see where the column possible_keys is NULL for every table? That
means that there are NO (none, zilch, nada, zero) indexes that can be used
to save your database engine from the trouble of doing a full table scan
for EACH AND EVERY MATCH in your query. I don't even see where you defined
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
on Thursday, October 07, 2004 1:34 PM said:
Can you see where the column possible_keys is NULL for every table?
That means that there are NO (none, zilch, nada, zero) indexes that
can be used to save your database engine from the trouble of doing