MySQL Forums
Forum List  »  Partitioning

Re: Count(*) query is slower on partitioned table
Posted by: Rick James
Date: December 21, 2016 12:35AM

By the time you are finished, each row is considerably wider than when you started. Bigger rows -> fewer per block -> slightly slower.

Probably the only difference between 30 and 1000 in your example is 1-byte versus 2-byte length field for that column.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Count(*) query is slower on partitioned table
316
December 21, 2016 12:35AM


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.