Application Development

Chapter 41 . Optimizing Applications

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