On 15-Apr-08, at 5:38 AM, Jonathan Ariel wrote:
My index is 4GB on disk. My servers has 8 GB of RAM each (the OS is 32
bits).
It is optimized twice a day, it takes around 15 minutes to optimize.
The index is updated (commits) every two minutes. There are between
10 and
100 inserts/updates every 2 minutes.
Caching could help--you should definitely start there.
The commit every 2 minutes could end up being an unsurmountable
problem. You may have to partition your data into a large, mostly
static set and a small dynamic set, combining the results at query time.
-Mike
