Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
akpaga
Constraint Violating Yak Guru
331 Posts |
 Posted - 2008-02-22 : 15:26:39
|
| I have stored procedure for select statement that goes thru four or five tables for retrieving data and this makes it very slow in executing. I am using this in a asp.net page for report and it takes a hell lot of time 6-7 mins before details are visible in gridview.how make the stored procedure faster?thanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-22 : 16:28:14
|
| Please post your code so we can tune your SP. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-23 : 03:47:22
|
| Make sure you have proper indexes in your columns involved in the first place. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-02-23 : 06:17:16
|
| How many records are you sending to ASP page?MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
slow copiling of stored procedure