Re: Minimum number of rows for using partitioning
Posted by:
Rick James
Date: December 12, 2009 10:58PM
Wrong questions. Instead, let's discuss your current schema and your proposed partitioning method. Some flavors of partitioning do not add any performance benefit, regardless of size.
Also in the equation... How much RAM do you have? MyISAM or InnoDB? Do you insert into the 'last' partition only? What are your SELECTs like?
Subject
Views
Written By
Posted
5206
December 10, 2009 10:57PM
Re: Minimum number of rows for using partitioning
2358
December 12, 2009 10:58PM
2656
December 13, 2009 09:57PM
2313
December 14, 2009 12:17AM
2658
December 14, 2009 12:57AM
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.