|
|
Re: enable synchronization of full-text index [message #522439 is a reply to message #522370] |
Fri, 09 September 2011 08:46 |
|
Barbara Boehmer
Messages: 9100 Registered: November 2002 Location: California, USA
|
Senior Member |
|
|
Ctx_cat indexes do these things automatically. With ctx_context inidexes you can use index parameter and/or scheduling to make the synchronization, optimization, and rebuilding automatic at whatever intervals you want. The more often that you synchronize, the more fragmented that your index will become, until you optimize. The more fragmented that your index is, the slower your searches will be. Also, the more DML that has been done before you synchronize and optimize, the longer it will take to do so. How often that you synchronize and optimize depends on your situation. If you need recent changes to be searchable immediately, then you need to sync(on commit). Synchronization and optimization can be done online, so that they do not interfere with searches. If your business has some downtime, such as weekends or nights, then that is a good time to schedule rebuilding. When in doubt, do a small test on your system, and see.
|
|
|
|
|
|