Application Development

Once the application is developed, you can optimize the performance in several key areas.

Database Fetches

The following items can affect the response time of database fetches:

• dm_set_max_rows_per_fetch—Sets the number of rows in each packet.

• Database indexes—Generate indexes, or additional indexes, on the database.

• Database access method—Instead of using the transaction manager, you can call stored procedures or SQL statements.

• Database locking method—In order to avoid having users waiting for database locks to be released, change to an optimistic locking scheme or deploy the application in a three-tier environment.

Web Applications

The following items can improve the performance of your Web application:

• Requester executable—Use the ISAPI or the NSAPI version of the requester executable, instead of the CGI version.

• Windows Web application servers—Use NTFS as the file locking system.

• Graphics—Place your graphics in the directory specified in the ImageDir variable to improve the loading of graphics files.

LDBs

The following items can affect the response time when using LDBs:

• Number of widgets in the LDB.