How long should indexing take?
Indexing text is a resource-intensive process. Obviously, the speed of indexing will depend on the power of the hardware involved, but you should expect somewhere between 50MB / hour on workstation-class NT machine (approx 400MHz CPU, 128MB memory) to more than 1GB per hour on a large multi-CPU, multi-gigabyte server machine. The latter figure assume you are using parallel indexing on a partitioned table – a new option for 8.1.6 – see the documentation for more details. For most real-life systems, the time to index a complete table of documents will be measured in hours, and in some cases days.
