Re: MySQL Performance or Just me? :(

[Tobin Harris]

You should paste your query here for us to see.

Have you run an EXPLAIN on the query to see if it's using an index? For example:

EXPLAIN select * from mytable where col = 'hello'

You can find details of how to interpret the EXPLAIN results in the MySql manual. In general, you should check that:

"type" is not saying "ALL" - this means all rows are being scanned
"possible_keys" - something should be shown here, indicating that at least one index can support your select statement
"key" - something should be here indicating the one index that was actually used.

HTH

Tobin