Progress/400
Product Guide
Query Processing
By default, the Progress/400 DataServer instructs the server to evaluate a query. This can enhance performance depending on whether your system is configured to maximize server processing abilities or network overhead.
To take advantage of the server’s query processing, use FOR EACH statements combined with GET NEXT instead of FIND and REPEAT combinations when programming in the Progress 4GL.
If selection by server is not optimal for your configuration, you can use the DataServer (-Dsrv SBS=0) startup parameter to prevent it and allow the client to evaluate database results.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |