
ODBC connections to the following database types assume that the ODBC database driver is also
thread-safe and, therefore, operate in a multi-threaded manner:
• Microsoft SQL Server
• Oracle
• DB2
• Teradata
• Sybase
Note:
It is also assumed that the database drivers used with JDBC and OLE DB are always thread-safe and,
therefore, always operate in a multi-threaded manner.
The following native database drivers are thread-safe:
• crdb_ado_plus.dll (ADO.NET data provider)
• crdb_com.dll (COM data provider)
• crdb_db2cli.dll (DB2 Unicode)
• crdb_javabean (Java Bean data provider)
• crdb_xml (XML)
• 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.
6.4.5 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 on stored procedures, see Stored procedures.
2011-05-16118
Designing Optimized Web Reports
urenrjrjkvnm
Cinema