Write Quick Find code in IBM Lotus Notes and Domino

Read the 11 tips for writing a quick find code in IBM Lotus Notes and Domino. The author examines @DbLookup in Lotus Notes and Domino @Formula and describes some new tricks for developers to use when writing new applications or troubleshooting performance issues with existing applications.
This article examines @DbLookup, which may be the most popular @Formula in IBM Lotus Notes and Domino. Today's Lotus Notes/domino application developers may not be able to imagine creating applications without using this formula, and more than 15 years of performance testing and customer troubleshooting have shown that this formula is often used dozens of times in a form in an application in a variety of forms.

But the same experience shows that performance problems are often associated with these @DbLookup formulas. As we've seen, complex enterprise applications get bogged down in real life by using these formulas, which leads to unacceptable low performance.

This article will describe 11 tips that can be used to ensure that almost any application runs faster. These techniques range from a simple line of code to a fundamental change in the way @DbLookup formulas are handled, but all of these techniques have been proven.

This article assumes that you have some knowledge of Lotus Notes/domino development, so some basic parameters, such as @DbLookup formulas, will not be mentioned.

This article uses a variety of examples to illustrate the value of each technique. For the sake of simplicity, we use a Help Desk application that contains a contact form and a Ticket form. The basic workflow for this application is to call the customer, create the Ticket document, and then, after obtaining the customer's company and name information, select the appropriate company name and contact name from the drop-down list. Also select the appropriate invocation category (for example, Product Help, Sales, and so on). Here are some examples of how @DbLookup formulas can be useful in these situations:

Select a company name from a list that contains all companies
Select a customer name from a list that contains all of the company's contacts
Select a problem category from a list of pre-determined or dynamic problem categories

。。。。。。

Click here to view full text