Re: Reasonable number of partitions?
Posted by:
Barry Boes
Date: September 20, 2007 08:36PM
Why not take advantage of InnoDB's primary key based on-disk ordering to help this performance? If you start the PK with the account# then the data will physically order itself into "partitions" on disk.
Subject
Views
Written By
Posted
7179
March 08, 2007 10:09AM
10388
March 09, 2007 12:39AM
4570
March 11, 2007 08:30AM
4908
March 13, 2007 09:53PM
5239
March 14, 2007 12:34PM
Re: Reasonable number of partitions?
3869
September 20, 2007 08:36PM
3645
September 12, 2007 11:26AM
3743
September 13, 2007 09:47AM
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.