What are the best practices for refreshing text indexes on SQL Anywhere 11.0.1, or useful criteria to help decide?
We are adding full text search into the next major version of our software, and are debating the wisdom of different text index refresh approaches.
We're looking for guidance on how to decide among IMMEDIATE REFRESH, AUTOMATIC REFRESH EVERY 1 (or 2) MINUTES, MANUAL REFRESH just before each query, etc. Things that might help are:
Thanks VERY much,
asked 04 Feb '11, 01:36
IMMEDIATE REFRESH text index only updates the data that has changed. MANUAL or AUTO REFRESH text indexes may need to be rebuilt from scratch from time to time. When this happens, the old copy of the index is available to the users for the duration of the rebuild.
When no data has changed, MANUAL and AUTO REFRESH run relatively fast.
IF the users will expect the newly inserted items to be visible in the full text search immediately, IMMEDIATE text index may be a good solution, however, one thing to keep in mind is that all the updates to the indexed values will become somewhat slower.
Just to clarify - a reasonable number of small documents added to an IMMEDIATE TEXT INDEX a minute on a not overly busy server should work well.