Thanks Christian,
AUTOOPTIMIZE seems to work quite well. So what database size do you consider to be "too large"? 0.5 Gb? 1 Gb? Or ... ?
Paul
Hi Paul,
Even so, after several insertions (using XQUERY insert node) I see that the UPTODATE flag is no longer checked
Basically, this is fine, because only the value index structures will be updated (excluding database statistics, meta data and the fulltext index).
and I have to run OPTIMIZE ALL to get back my performance.
Maybe you can compare the query plans before and after an update and see what has changed?
a) Is there a way to keep UPTODATE checked under all circumstances? And if not b) Is is advisable to run OPTIMIZE ALL after every insertion? (I guess not)
You can set AUTOOPTIMIZE to true [1]. This works fine as long as your database doesn't grow too large. In every case, it's faster than OPTIMIZE ALL, because only those data structures will be reorganized that have become outdated.
Besides that, using OPTIMIZE (without ALL) may already be sufficient.
Hope this helps, Christian