SQL Server Performance

Crystal Reports SQL Server Optimal Solution

Discussion in 'Non-Transact SQL Developer Performance Tuning' started by campbellcanuck, Jul 25, 2005.

  1. campbellcanuck New Member

    I'm looking for some information about the best way to connect a Crystal Report to a SQL Server 2000 db. I am being required to provide information on performance issues in order to decide on the process that will be implemented in an intranet environment.

    The 2 schools of thought are:

    1. Use stored procedures that will take as parameters the values that the results will be filtered by. No dynamic SQL, temporary tables or cursors will be used.

    2. Use Crystal's built in filtering and connect directly to a view which will contain all of the fields that are required by the report.

    If anyone has any performance testing data or can provide links to information regarding this issue please post here.

    Thanks in advance.
  2. satya Moderator

Share This Page