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
7451
March 08, 2007 10:09AM
10538
March 09, 2007 12:39AM
4688
March 11, 2007 08:30AM
5011
March 13, 2007 09:53PM
5360
March 14, 2007 12:34PM
Re: Reasonable number of partitions?
3987
September 20, 2007 08:36PM
3762
September 12, 2007 11:26AM
3867
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.