Re: Is my hardware slow or is it MySQL performance?

[mike wylie]

Sorry I've just re-read my post, it is a little misleading. I am actually trying to find out if my query _duration_ is as expected.

A query that for example compares against, in my example 'type', takes four mins or so.

select * from cpath where type = 'XXX';

The column only has a few distinct values, so an index probably won't help. I would possibly split the table out into a different relational layout if i had my way, but that isn't possible.

So in a nutshell is my 4.5 min query time normal, or would somebody more experienced say I have configuration issues.

Regards Mike

PS sorry for the slow replies.