Progress
DataServer
for ORACLE Guide


Writing Queries for Performance

This section provides a collection of tips and guidelines to follow when writing queries. For example, a query that processes a large number of rows performs best if it uses NO-LOCK, lookahead cursors, a large cache size, and a small field list. The following suggestions might help improve the performance of your DataServer applications. Try some of these and use the DEBUG diagnostic options to gather statistics on how your application runs. See the "Analyzing Performance" section in "Connecting the DataServer" for information on collecting statistics:


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095