Scenario 1 – As a Notes user, you search a database and notice that you only got 5000 documents back. Where are the rest?
Scenario 2 – As a Domino developer, your code searches a database and only returns 5000 documents for processing. What is wrong with my code?
You’re in luck. You didn’t do anything wrong. Notes and Domino have a default setting that limits the number of documents returned when performing a search. This limit is 5,000. We can make a change to the notes.ini to increase the number of documents returned.
Full-text Database
To control the number of documents returned in a full-text indexed database, we need the following entry added to the appropriate notes.ini
FT_Max_Search_Results=x
x can have a max setting – 2147483647 (Use just the number. No comma or decimal points)
Non-Indexed Database
To control the number of documents returned in a non-indexed database, we need the following entry added to the appropriate notes.ini
Temp_Index_Max_Doc=x
x can have a max setting – 2147483647 (Use just the number. No comma or decimal points)
Remember that the database location determines which notes.ini needs the above settings. For example, if the database is on your local machine, you will need to add these entries in the Notes client’s notes.ini. Likewise, add these entries to the Domino server notes.ini when the database is on the server.
