Querying

Previous Next

As a rule, use standard generated Rules Engine SQL statements wherever possible, use joined columns rather than GUI-designed fields, and use Main Queries and Extra Queries rather than manually programmed behavior.

This is particularly important in the light of maintenance of the application and the possibility of making changes to it at low cost.

Moreover, using standard generated SQL statements where possible will also generally improve performance. This is because cursors are likely to be re-used, and because a number of customized or preset strategies for optimizing SQL statements are more likely to yield effect on default generated SQL statements than on complex customized joins and subqueries.

This section presents some detailed tips to improve the performance regarding querying.

See also

Use Static Tables

Define Additional Indexes

Do Not Allow Open Queries

Query Mandatory

Query Some Mandatory

Check Count Query

Synchronize Lookup

Use Screen Values

Optimize Joined Column Fetch

Remove Columns from Main Query

Limit Query Buffer Size