Special Edition Using® Crystal Reports® 10

Performance and Implementation Considerations

There are certain factors that an organization should take into account before implementing Business Views. Because many people will likely use each Business View, care should be taken when building the query to ensure that performance meets expectations. Additionally, because of the increased functionality (such as joining two data sources), you might be tempted to simply create a structure that fulfills business requirements but sacrifices performance. Although most of the performance considerations are exactly the same as those for Crystal Reports design, some of the most common pitfalls are considered in the following sections.

Joining Large Data Sets

It is recommended to keep disparate data source ...