MySQL Forums
Forum List  »  Performance

Re: Is my hardware slow or is it MySQL performance?
Posted by: mike wylie
Date: October 14, 2005 09:21AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Is my hardware slow or is it MySQL performance?
1468
October 14, 2005 09:21AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.