Re: COUNT(*) very slowly in large InnoDB table
Hi,
Please don't mistake me if I am asking the same thing .I understand that MyISAM is designed to perform count(*) in a optimal way.I am also aware of the following fact answered in mysql forum earlier 'Bottom line: Use COUNT(*) unless you are explicitly counting non-null items.'
Under the situation where my table is InnoDB and assume it has quite large number of records,which should i prefer Count(*) or Count(id) from a performance perspective.consider id as the primary key.Are both ok to use in such a case keeping performance in mind ?
Thanks in advance.
Abilash
Edited 1 time(s). Last edit at 07/19/2010 12:21PM by abilash vs.
Subject
Views
Written By
Posted
31112
July 13, 2010 11:43AM
9736
July 14, 2010 11:04PM
7404
July 15, 2010 02:24AM
7191
July 15, 2010 08:51AM
3940
July 15, 2010 09:48AM
3733
July 15, 2010 09:09PM
3218
July 16, 2010 12:58AM
Re: COUNT(*) very slowly in large InnoDB table
4122
July 19, 2010 12:18PM
4645
July 19, 2010 12:45PM
3936
July 19, 2010 09:25PM
3267
July 20, 2010 10:38PM
2609
July 21, 2010 11:52AM
3752
July 21, 2010 12:11PM
3951
July 22, 2010 03:23AM
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.