Home
HCL Domino Designer Basic User Guide and Reference
This guide provides information on using HCL Domino Designer and programming language reference information.
Application Management
Welcome to the Application Management section of Domino® Designer Help.
Procedure for optimizing and troubleshooting databases
Troubleshooting database performance
You can reduce database performance problems by using:
Users experience a delay when accessing the database
Users may experience a delay when accessing databases for the following reasons:

HCL Domino Designer Basic User Guide and Reference
This guide provides information on using HCL Domino Designer and programming language reference information.
- What's new in HCL Domino Designer 11 for developers?
  The following features are new for developers in HCL Domino® Designer 11.
- Accessibility and keyboard shortcuts
  Accessibility features assist users who have a disability, such as restricted mobility or limited vision, to use information technology content successfully.
- Application Design
  Welcome to the Application Design section of Domino® Designer Help.
- Application Management
  Welcome to the Application Management section of Domino® Designer Help.
  - Security in an application
    Domino® offers a multi-layered approach to security. Server administrators can secure databases, servers, and domains. Database designers and managers control the following:
  - Completing an application and managing design changes
    As you prepare to deploy an application, consider these finishing touches:
  - Deploying an application
    The tasks involved with application design, database design, database management, and DominoTMsystem administration may overlap, depending on the size of your organization and the structure of job responsibilities. In some organizations, an application developer may be responsible for both application and database design, while in others, a database manager may handle all database design and management tasks. In addition, database management overlaps with Domino® system administration.
  - Procedure for optimizing and troubleshooting databases
    - Properties that improve database performance
      Properly setting database properties can improve the performance of an active database. Setting database performance properties on many databases or on one, large, active database can also improve server performance. In addition, some of these property settings also help reduce the size of databases.
    - To set database properties that optimize database performance
    - Controlling database size
      Databases whose size is monitored and minimized show increased performance: database operations require less I/O and fewer CPU resources; view rebuilding and updating is quicker; and memory and disk space allocation is improved. The maximum database size is 64GB on Windows™ and UNIX™. Use the following methods to regularly monitor the size of databases and minimize database size:
    - Document archiving tool
    - Monitoring replication of a database
      If there are replicas of a database, use any of these methods to monitor replication daily.
    - Monitoring database activity
      Monitor database activity regularly. If database activity is high and users report performance problems, do any of the following:
    - Notifying users of a moved database
      After you move a database, create a new database with the same file name and path as the database before you moved it. In the new database, create a form and document that provides the following information:
    - Troubleshooting database performance
      You can reduce database performance problems by using:
      - Users cannot access the database
        Users may not be able to access databases for the following reasons.
      - Users experience a delay when accessing the database
        Users may experience a delay when accessing databases for the following reasons:
      - Using Find Note to analyze a document reported in the log file
        You can use the Find Note dialog box in the Domino® Administrator to analyze a document reported in the log file. If the log file reports a problem with a document, you can display the properties for the document to help you to troubleshoot the problem. For example, you can use Find Note to review the document properties for a document that cannot replicate.
    - Troubleshooting replication problems
      The following topics suggest solutions to common problems associated with scheduled replications.
- Domino® Query Language
  Domino® Query Language (DQL) is a facility running on a Domino server that provides a terse, shorthand syntax for finding documents. It supports a wide variety and complexity of search terms. It leverages existing design elements, avoiding the need to write detailed code to access them. DQL consolidates all methods in Domino for searching document contents.
- Composite Applications - Design and Management
  Composite applications are a key element in a service-oriented architecture (SOA) and contextual collaboration strategy. The ability to create and edit composite applications lets you easily integrate different types of components and technologies.
- DB2® Access views
  Domino® Designer includes two types of design elements to assist you in managing data contained in DB2® enabled Notes® databases:
- Programming Overview and User Interface
  This section contains general guidelines and examples that show where to use Java, LotusScript, and the formula language.
- Formula Language
  This section documents the formula language.
- LotusScript® Language
  Welcome to the LotusScript® Language section of Domino® Designer Help.
- LotusScript/COM/OLE Classes
- Java/CORBA Classes
  This section documents the Java/CORBA classes.
- Connectors
  Connectors provide native access to a wide variety of DBMS products, ODBC, the platform File system, Enterprise Resource Planning systems, and Transaction Processing systems.
- Javadoc™ for Domino® Designer related APIs
  As part of providing additional Java™ reference documentation, Domino® Designer ships with a help plugin that contains Javadoc™ for additional Domino Designer related APIs.

Users experience a delay when accessing the database

Users may experience a delay when accessing databases for the following reasons:

The database is heavily used

View the User Activity dialog box to see if the database is heavily used. This option is on the Information tab of the Database Properties box. Check the server to see if its hardware and memory are powerful enough to support the user activity for the database. If the server is not powerful enough, you may need to upgrade hardware or memory on the server. You can also create an additional replica of the database so all users are not always using the same one. If disk contention is a problem, move the database to a less heavily used disk.

There are too many views

If the database contains many views, consider consolidating some of them. For example, you can consolidate views by creating alternative collations in the same view, rather than using separate views. Database performance can suffer when a database contains many views.

View indexes are being refreshed too frequently

If the database is heavily used or contains many documents, refresh view indexes less frequently, if possible.

Unread mark processing may cause delays

Delays can occur as the unread marks in a database are updated while the database is opening. It also creates disk contention, which slows down every operation on the database. Disabling unread marks on the database eliminates the delay.

The database design is complex

A complex database design can cause performance problems. Consider simplifying the database design.

Database performance properties are not being used

If feasible, set database properties to improve database performance.

The database cache needs adjustment

If you are a system administrator, monitor the database cache on the server that stores the database to see if it's working effectively. If necessary, increase the number of the databases the cache can hold. The NSF buffer pool size may also need to be increased.