Index Partitioning should be a good idea.
It'll save a lot of time on index merging, incremental indexing.
Just my experience, partition size really depends on CPU, hard disk speed,
and memory size. Nowadays with Core 2 Duo, 10G size for each chunk should be
good.
--
Chris Lu
---
Hello All,
I want to hear from those out there that have large (i.e. 50 GB+)
indexes on how they have designed their architecture. I currently have
an index for email that is 10 GB and growing. Right now there are no
issues with it but I am about to get into an even bigger use for the
softw
