Kbase 15062: Performance hints for the Report Builder Engine
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
Performance hints for the Report Builder Engine
Performance in the Report Engine is influenced by
whether the filter is evaluated on the server or the
client machine.
FAST - When the filter is evaluated on the server only
the records that match the filter criteria are transferred
over the network.
SLOW - When the filter is evaluated on the client all the
records in the specified table(s) are transferred over the
network to the client machine. Then the filter is used to
select the records to display in the report.
- In V7.3A the filter override in the RB-FILTER parameter
will be evaluated on the client.
- In V7.3B the filter override in the RB-FILTER parameter
will be evaluated on the server EXCEPT when the operator
used is specifically not server-evaluatable. See the
Report Builder Manual, Calculated Fields chapter,
Server-evaluatable fields section for a description
of what makes a field server-evaluatable. The same
rules apply for filters.
(Note: There is a bug in V7.3B that causes the >, >=, <, <=
operators to not process correctly when they are used in the
RB-FILTER parameter. This is fixed in patch V7.3B03)
- See the Report Builder Manual for server-evaluatable
fields and operators and server evaluatable filters and operators.
- Passing a runtime variable through the 19th parameter to the filter
will always cause the filter to be evaluated on the
client. This is true for all versions of Report Engine.
Runtime variables can be passed in through the
RB-FILTER parameter. Refer to the following kbases:
13735 Report Builder override filter character runtime variable
13736 Report Builder override filter with numeric runtime variable
Progress Software Technical Support Note # 15062