On Mon, Aug 3, 2009 at 10:51 AM, Michael
Gould wrote:
> The total size of our database with 5 years worth of data is about 3.4 gig.
> In the business we are in, we open about 5-7 new locations each year and
> close 2-3. I was also thinking that if each partition was by location it
>
It seems to m
Michael Gould wrote:
2. can you come up with a pattern you can use to segment your data into
smaller chunks (like weeks, months, ids) to create partitions reasonably
big but not huge
Yes, each location has their own specific location code.
good!
how many rows you will have per each l
Michael Gould wrote:
I am considering whether or not to partition a few tables in our system.
The guide lines I read said that this could help when the size of a table
exceeds the amount of system memory. I'm wondering if this statement should
be table or database.
The way our system operates
I am considering whether or not to partition a few tables in our system.
The guide lines I read said that this could help when the size of a table
exceeds the amount of system memory. I'm wondering if this statement should
be table or database.
The way our system operates is that each individual
