Hi guys,
I have faced slow server performance due to immediate frequency of updating full text indexes for the mail databases. I’ve got around 1200 mail database here. Can any one suggest how I can change the update frequency of all 1200 database in one single shot?
Any suggestion regarding improving server performance would be appreciable.
Thanks & Regards
Erfaan
Subject: How to set update frequency on full text index for more than one database?
Hi,
There are a couple of notes.ini parameters you can add. I will give you some but you have to check it in your environment.
FT_Index_Ignore_Attachment_Types=.BMP,.ZIP,.ID,.SHB,.GIF,.JPG,.NSF, .NTF,.EML,.EXE,.DLL,.CAB,.PNG,.WAV,.JPE,.JPEG,.AVI,.MPG,.MPEG,.MP3
View_ReBuild_Dir=/tmp/
Updaters=3
The first item will prevent update to try to index pictures, binary files, and so on. Files who no one need to know words inside them. The second item is where the server perform rebuilds. In my case, /tmp is another disk. On windows environment you can use a drive letter, as “e:\tmp”. It’s a good idea to rebuild indexes on another disk, or even using another SCSI controler. The third item will tell the server how many updates to do in a time. This one can afect performance if you put a high number. IT uses a lot of CPU AND Hard disk!!! If you use only one, the server will take a lot of time to update all databases.
Take a look in Dr CC site, and check for other restrictions you can add to your notes.ini. Besides, consider to add transaction log. Don’t forget transaction log on windows need an extra SCSI controler!!!
You can also consider to use an agent to change index frequency in each mail database, but this can cause problems with users. Another option you can think about it, is create archive databases to shrink size of mail files.
HTH
Daniel
Subject: RE: How to set update frequency on full text index for more than one database?
FYI: in R6.5.4 I find this in the help documentation.
Syntax: FT_Index_Attachments=value
Description: Specifies whether to exclude types of document attachments in the Domain Index that are not already excluded by default. A value of 1 includes these document attachments in the index, and a value of 2 excludes them. The following types of attachments are excluded from the Domain Index by default: .au, .cca, .dbd, .dll, .exe, .gif, .img, .jpg, .mp3, .mpg, .mov, .nsf, .ntf, .p7m, .p7s, .pag, .sys, .tar, .tif, .wav, .wpl, .zip.
Applies to: Servers
Default: 1
UI equivalent: None
Subject: How to set update frequency on full text index for more than one database?
The C and C++ APIs do not currently expose the FTindex frequency setting. Pity.
However, there is a simpler solution. You could write a LotusScript agent - use the DbDirectory class to iterate through all the databases in the mail folder, then set the db.FTIndexFrequency property = to one of the following values (taken from the Designer help on FTIndexFrequency)
FTINDEX_DAILY (1)
FTINDEX_HOURLY (3)
FTINDEX_IMMEDIATE (4)
FTINDEX_SCHEDULED (2)
You might want the agent to run daily or weekly - just in case your users set it back to immediate.
There is also a Notes.ini parameter for disabling FTIndexing on the server (maybe this is a bit drastic though).
Subject: recreate all the indexes?
Delete all the *.ft folders for the mail files. Go into Domino Administrator and select all the mail files. Choose Database | Ful Text Index and recreate them with correct update frequency.
I don’t have the Domino Administrator client right now but wouldn’t that work?
Hans
Subject: RE: recreate all the indexes?
No this will recreate all the indexes as it was before you deleted the .ft folders.
Daniel
Subject: How to set update frequency on full text index for more than one database?
I have compiled a longer answer to this on my blog at http://domainpatrol.org/dp/blog.nsf/d6plinks/76KUD2
Peter Närlund
Subject: Sounds like a job for the Notes C API.