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
6778
March 08, 2007 10:09AM
10055
March 09, 2007 12:39AM
4399
March 11, 2007 08:30AM
4732
March 13, 2007 09:53PM
5014
March 14, 2007 12:34PM
Re: Reasonable number of partitions?
3683
September 20, 2007 08:36PM
3465
September 12, 2007 11:26AM
3581
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.