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
6676
March 08, 2007 10:09AM
9955
March 09, 2007 12:39AM
4341
March 11, 2007 08:30AM
4675
March 13, 2007 09:53PM
4960
March 14, 2007 12:34PM
Re: Reasonable number of partitions?
3637
September 20, 2007 08:36PM
3426
September 12, 2007 11:26AM
3542
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.