Re: Is my hardware slow or is it MySQL performance?
With Myisam table, select count(*) from cpath should return in an instant without scanning the full table.
However, select count(*) from cpath where id > 0, will cause an index scan on the Primary key `id`.
Still not a full table scan.
Subject
Views
Written By
Posted
2301
October 05, 2005 08:02AM
Re: Is my hardware slow or is it MySQL performance?
1370
October 05, 2005 07:24PM
1261
October 07, 2005 06:27AM
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.