I am working with an application could return several 1000
documents for each query, and there could be several users
working simultaneously on the application. In short all
queries need to return results instantaneously.

1. Other than upgrading hardware (memory, processor speed,
disk speed and channels) is there anything else that can
be done to improve performance?

2. Will limiting the number of rows (lets say 200)
returned improve performance?

3. Which hardware resource (memory, disk speed, processor
speed) will have the greatest impact on the performance.

Thanks,
Ashhad.