What is the fastest way to search for documents in database using lotusscript?

HCL Domino Domino Forum
1

Hi

I need to know this in order to find out if the cause is the machine the server is on.

I have a lotusscript code that uses the Search method of the notesdatabase class to find documents. I run this code ( which is in a view action) manually. It takes really about almost 15 minutes before the search is finished.

I dont think this is normal. Is the search method not a good thinig to use when searching for documents to make a collection? Or is this method normally quick? Or are there other ways that are faster in lotusscript?

Kind Regards

2

Subject: What is the fastest way to search for documents in database using lotusscript?

I got a perfect answer for you, Raphael and I just published an article about this very topic:IBM - United States

The link has been added to the Agent FAQ, of couse, under performance:

http://www-10.lotus.com/ldd/46dom.nsf/7e6c7e584a76331b85256a46006f083e/574c99ccb345839185256976004e811e?OpenDocument

3

Subject: What is the fastest way to search for documents in database using lotusscript?

Have a look here: Application Performance Tuning, Part 2

http://www-10.lotus.com/ldd/today.nsf/a2535b4ba6b4d13f85256c59006bd67d/0c59c2787af5c1a685256d1600552fce?OpenDocument

There is a detailed explanation at the end of the text.

Bye

Hynek

4

Subject: What is your Search Formula? 15 Minutes is a long time.

Do you have “Optimize document table map” Database property set (last tab)? How many documents in the Db? I have searched 50-100K document db in 1-2 seconds.