MySQL Forums :: Partitioning :: Count(*) query is slower on partitioned table


Advanced Search

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
Count(*) query is slower on partitioned table 626 Darren Demicoli 12/03/2016 11:53AM
Re: Count(*) query is slower on partitioned table 222 Rick James 12/10/2016 12:30AM
Re: Count(*) query is slower on partitioned table 263 Darren Demicoli 12/10/2016 06:48AM
Re: Count(*) query is slower on partitioned table 213 Rick James 12/12/2016 01:56PM
Re: Count(*) query is slower on partitioned table 241 Darren Demicoli 12/13/2016 02:50PM
Re: Count(*) query is slower on partitioned table 175 Rick James 12/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.