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



  • Favorite iSeries cheat sheets

    Here you'll find a collection of valuable cheat sheets gathered from across the iSeries/Search400.com community. These cheat ...

  • HTML cheat sheet

    This is a really cool cheat sheet if you're looking to learn more about HTML. You'll find just about everything you every wanted ...

  • Carol Woodbury: Security

    Carol Woodbury