Jump to main content
HCL Logo Product Documentation
Customer Support HCLSoftware U Community Forums Customer Idea Portal
IBM Domino Designer
  • IBM Domino Designer Basic User Guide and Reference
  • Designer XPages User Guide
  • JavaScript and XPages reference
  1. Home
  2. IBM Domino Designer Basic User Guide and Reference

    Basic product usage information and programming language reference information.

  3. Application Management

    Welcome to the Application Management section of Domino® Designer Help.

  4. Procedure for optimizing and troubleshooting databases
 Go to Feedback
  • IBM Domino Designer Basic User Guide and Reference

    Basic product usage information and programming language reference information.

    • Application Design

      Welcome to the Application Design section of Domino® Designer Help.

    • Domino® Designer templates

      The templates described in the following table are available with Domino® Designer and are specifically intended for use by application developers.

    • Importing to and exporting from views
    • Developing applications using MAPI

      Domino® Designer Release 6 and later supports the messaging application program interface (MAPI), which allows mail integration between Domino and a MAPI-compliant messaging application, such as Microsoft™ Outlook, Microsoft Office applications, or user-written C++ programs.

    • Features to avoid using in Web applications

      Developers creating applications specifically for the Web, or for the dual purpose of serving Notes® and Web clients, should review the following tables for features that are not supported on the Web.

    • URL commands for Web applications

      You have a variety of options for programming a Web site. You can directly manipulate objects such as documents or views in an application using Domino® URL commands. Adding Domino URL commands as HTML in forms gives users shortcuts for navigating databases and performing other tasks quickly.

    • 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:

        • Troubleshooting replication problems

          The following topics suggest solutions to common problems associated with scheduled replications.

    • 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.

    • Lotus® Connectors

      Lotus® 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.

    • 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.

Procedure for optimizing and troubleshooting databases

About this task

Set advanced database properties to:

  • Optimize database performance
  • Enable or disable transaction logging
  • Allow more fields in a database
  • Allow soft deletions
  • Support Response Thread History
  • Don't allow simple search

  • Use LZ1 compression for attachments
  • 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:
  • Troubleshooting replication problems
    The following topics suggest solutions to common problems associated with scheduled replications.
Related information
  • Properties that improve database performance
  • To set database properties that optimize database performance
  • Share: Email
  • Twitter
  • Disclaimer
  • Privacy
  • Terms of use
  • Cookie Preferences