Message-Id: <10544.110981@fatcity.com> From: "MacGregor, Ian A." Date: Fri, 30 Jun 2000 11:25:45 -0700 Subject: When to Partition 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@slac.stanford.edu