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.
Subject
Views
Written By
Posted
2301
October 05, 2005 08:02AM
1371
October 05, 2005 07:24PM
1261
October 07, 2005 06:27AM
Re: Is my hardware slow or is it MySQL performance?
1468
October 14, 2005 09:21AM
1543
October 15, 2005 02:59PM
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.