Lookup on web

HCL Domino Domino Forum
1

Hello,

On the web i am doing a lookup to find a specific document. I use a dblookup function in a database which contains 177.000 documents.

The lookup on the web works very slow, it takes about 4 minutes to find the document.

Is there a way to reduce the lookup time? I have the index set to ‘Immediate’

Thanks!

2

Subject: Lookup on web

There are some basic ways to speed up a lookup1) use a cached dblookup if at all possible

  1. Make sure your lookup view only has one sorted column, and preferably only one unsorted, contain the data you need

  2. Lookup data from a view column, not from a field

  3. Only do the lookup once

(e.g.

result = @dblookup(blah blah);

@if(!@iserror(result);result;errorstuff)

  1. Make sure you don’t have same-named views, folders & navigators
3

Subject: RE: Lookup on web

Thanks Christopher!

I used 5 lookups, tmp1=lookup1, tmp2=lookup2 etc. Your solution works much quicker!!!

Thanks!

4

Subject: Lookup on web

do you need to lookup against all 177,000 documents or is there a way you can have a subset in different lookup views?