HP Intelligent Management Center Standard Software Platform - Manual (Page 177)

• crdb_olap.dll (OLAP)
• crdb_oracle.dll (Oracle)
• crdb_p2ssby10.dll (Sybase)
Note:
Check the Release Notes in the Crystal Reports product distribution for
updates to these lists; more database drivers may be added if they are found
to be thread-safe during testing.
Using stored procedures for faster processing
A stored procedure is a compiled SQL program, consisting of one or more
SQL statements, which resides and runs on your SQL server. Although stored
procedures can take time to set up properly, they can be incredibly powerful.
The advantages of using stored procedures are most noticeable when
reporting off large sets of data, or when running reports that demand long,
complex calculations. In such cases, you should ideally use a predefined
stored procedure that performs the complex work for you on the database
server.
Because stored procedures reside on your SQL server, you may need to
ask your Administrator about accessing or setting up a stored procedure.
For more information
• For more information on stored procedures, see Stored procedures .
• To select a stored procedure as a data source, see "SQL stored
procedures" in the online help.
Using enhanced record selection formulas
The most important thing you can do to speed up report processing is to limit
the amount of data that is returned from the database. Your primary tool for
doing this is the record selection formula.
Crystal Reports 2008 SP3 User's Guide 177
8 Designing Optimized Web Reports
Using enhanced record selection formulas