Document Search

HCL Domino Domino Forum
1

Hi,

I have 90,000 Document in one database. While Creating new Document It checks exising document for duplication validation…It takes around 2 mins to create new docuement…Is there any best method to search these many documents or any alternative to reduce the time for creating the document…

Please suggest…

Thanks!

Abhishek

2

Subject: Document Search

You need to explain what you’re doing in more detail. Even with 90k+ documents it should never take anywhere near 2min to min to do something like a db.search. Are you traversing the documents one by one using view.GetNextDocument?

3

Subject: RE: Document Search

I am trying this …everytime Creating new document…

Set collection = db.Search(searchFormula, dateTime, 0)

Thanks!

Abhishek

4

Subject: RE: Document Search

what in your query string (searchFormula)

5

Subject: RE: Document Search

To find whether a field is duplicated in an existing document, use a view that’s sorted by that field. @DbLookup or various LotusScript methods can very quickly search the view for an existing key.

Avoid db.Search when you can – since it has to examine every document in the database, it’s going to be slow. A sorted view can be searched with a binary search, so you get a result very quickly.

6

Subject: RE: Document Search

Andre,

That is Really Great Idea ,Thanks a lot…

Abhishek