Why retrieve data slow when use store procedure in crystal report XI?
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?
Jason Long replied
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.
3) Network speed.