Do you know of a script to auto-delete the index and recreate it by a schedule?

I'm having a problem with full text indexes. Every day many users create or update a document, which causes the full text indexes to increase the size. If the full text indexes size gets very large, the full text search becomes very slow and sometimes I need to delete the index and create again the index.

Do you know of a script to auto-delete the index and recreate it by a schedule instead of manually?
I'm not familiar with any problem of full-text indexes growing over time. What version of Notes are you using?

I don't think it should be necessary to delete and recreate it. But in Notes 6, you can use the RemoveFTIndex and UpdateFTIndex methods to delete and recreate the index. In earlier versions, I'm not sure -- you could try just deleting the ".ft" directory, which should force the server to recreate the index the next time it's used (or when your agent calls UpdateFTIndex).

You might want to look at ways to limit the number of documents and the number of modifications and document creations, which can cause performance problems in all aspects of operation, not just full-text searches. Often I see applications that can be streamlined by combining several forms into a single form, reducing the number of documents considerably. This is particularly the case where the Notes database has been made overly "relational" in structure, with parent documents and subsidiary "line item" documents to reproduce the structure of a one-to-many relationship from a relational database. You may be able to use a table editing tool to reduce this to one document containing a multi-row table. You might also think about archiving old documents.

Dig Deeper on Lotus Notes Domino Administration Tools



  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...