May i know why retrieve data so slow when i use store procedure in crystal report? Can i know any way to spedier the data retrieving using store procedure?
I am using ODBC (RDO) connection. It load very slow until the data display. While i bind it in asp.net, then it will show runtime error. Database used is SQL Server 2000 where the store procedure located.
- turn on the options u2018Use Indexes or server for speedu2019 and u2018Perform grouping on serveru2019 in u2018Fileu2019 | u2018Report Optionsu2019 and check if it makes a difference in performance.
-To execute the stored procedure in SQLCON32 and see how much time it takes to?
-To run the report using native driver connectivity.
As long as you are using the correct ODBC driver (the one for SQL Server) your retrieval speed will depend on the following:
1) The performance of the SP itself. Run it from the SQL Management Console and note how long it takes to run. If the times are excessive, check the SQL code and see if you and do anything to clean it up & speed it up. You should check out the execution plan for the SP. A Google search for "SQL execution plan" should give you the details.
2) Make sure you are only calling the records you need. If you only need 10,000 from a table that holds 10,000,000 records, don't call all 10,000,000.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.