Minimum number of rows for using partitioning
Hi,
I have some tables which have 1 million to 20 millions records. Currently I don't see any big performance hit while accessing(select/insert) the table due to indexing. But I would like to improve the performance using partition. I guess there might be some overheads to mysql while using partitions for small tables. But I am not sure. Kindly give your valuable suggestions for the below questions.
What are the minimum number of rows for using table partition will produce better performance ?
What are the minimum/maximum number of rows per partition will produce better performance ?
Thanks,
Ramesh
Edited 1 time(s). Last edit at 12/11/2009 01:04AM by Ramesh Kumar.
Subject
Views
Written By
Posted
Minimum number of rows for using partitioning
5194
December 10, 2009 10:57PM
2352
December 12, 2009 10:58PM
2650
December 13, 2009 09:57PM
2308
December 14, 2009 12:17AM
2652
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.