We just released version 2.5 of the FoxWeb Full-Text Search class. This version re-uses records instead of marking them for deletion.
Sent by FoxWeb Support on 03/08/2006 03:57:49 PM:
The class deletes records whenever you call the UpdateRecordIndex method. Consequently, if you often update, or delete records from your indexed table, you may end up with large numbers of deleted records.
It would be possible to subsequently re-use these records and will look into this possibility for a future release, but my recommendation is to occasionally (once a week?) rebuild the index from scratch with the UpdateIndex method. This will not only remove all deleted records, but will also remove any discrepancies between the index and the actual data. Such discrepancies may be a result of changes made to the actual data, without subsequently calling the UpdateRecordIndex method.
Sent by David Younger on 03/06/2006 07:49:41 PM:
I notice that the size of FTS index tables gets very large very quickly.
On analysis, it appears that there are many deleted records created each time you update the index.
Can these deleted records be reused instead of allowing the size to bloat?
This is causing a performace degredation.