It's time to look at upgrading our servers and possibly upgrading our
database options. In particular I'm looking at obtaining the partitioning
option. However, I don't know the threshold at which partitioning becomes
useful; i.e., about what size is a large table? Is this size based on the
amount of space the table is consuming or it's actual size? When
partitioning to avoid insert hotspots, is there a formula that is used to
determine the optimum number of partitions?
Ian MacGregor
Stanford Linear Acclerator Center
ian_at_slac.stanford.edu
Received on Fri Jun 30 2000 - 13:25:45 CDT
