r1xliquid
Posts: 41
|
| Posted: 11/07/2007, 7:45 AM |
|
I have upgraded to CCS 3.2. All of my pages are driven by stored procedures populating editable grids. I have noticed a considerable slowdown on these pages. I am using mssql. Viewing DB activity through sql profiler i see that the stored procedures take 15-20s to hit the sql server after hitting the submit button.
When i run the stored procedures from query analyzer they take FAR less time, most times 5-10s. Through CCS using asp these pages are taking 40-100 seconds to return.
Has anyone else experienced this problem? Is there something i can do to speed thigns up?
|
 |
 |
Edd
Posts: 547
|
| Posted: 11/08/2007, 5:29 AM |
|
Check the following:
1. You are using an OLEDB connection NOT a ODBC connections
2. Look at the recordset size to ensure that you are not returning too much data. Remove unused fields, example Memo/Text fields are quite slow.
Stored procedure times should be better, but it is still a concern that you have a 5 to 10 sec response as it highlights that the stored proc needs work for use in a web site - aim for 2 second max.
Hope this helps
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
|
|
