We are using Domino Keyword Lookups to return all our selections for a range of fairly complex forms. These Lookups range from Business Units to Products Types etc. and may be cascading e.g. I select a Business Unit and then I want to get a list of departments for that BU and then the Products for that BU / Department Combination.
Some of Lookups are large (30K + records) and performance is not great via DIIOP.
How can we improve the performance of these lookups. Would implementing Web Services provide any performance improvement ?
Any other suggestions ?
This topic has been locked.
2 replies Latest Post - 2008-08-01T13:43:52Z by SystemAdmin
Pinned topic Domino Keyword Lookups
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2008-08-01T13:43:52Z at 2008-08-01T13:43:52Z by SystemAdmin
bosox 060001F02P20 PostsACCEPTED ANSWER
Re: Domino Keyword Lookups2008-08-01T12:51:43Z in response to SystemAdminThe first option I would explore is limiting the number of records you return. The best way to do this is to design a UI that forces the user to be more specific about what records they want to work with. For example, you could provide a select list with options for the user. Selecting one of the options could be used to return only those records associated with that option.
A second option is to implement paging where only X records at a time are returned.
If you can't use either of these two options (i.e. you have a hard requirement to return 30K+ records), you could implement caching. The first fetch would still be slow, but every fetch by every user after that who gets the same data would be instantaneous.
Have a look at this wiki topic related to performance of your application:
There is also a technote with additional details:
SystemAdmin 110000D4XK334 PostsACCEPTED ANSWER
Re: Domino Keyword Lookups2008-08-01T13:43:52Z in response to bosoxThanks bosox.
We are doing most of these things already where we can.
Our main issue is keyword lists that return large numbers of items for selection of Product etc. We are already using cascading lookups, but this forces screen refreshes etc. and there are still a large number of documents.
Would implementing Web services prvide any performance improvement over the Domino Keyword List builder in a cascading keyword implementation ?