If i execute sp from query analyser then it take only max 4-5 sec. but same sp if i execute from asp.net ,using ado.net , using following code, it take 15-20 minutes.
da.fill(ds);
above statement takes 15-20 minutes. My sp return only max 15 records.
Please tell me what to do?