1
Answer

Query processing

Vamsi k

Vamsi k

6y
517
1

Hi All,

 We have a select query which gives 50 records. So when we load that in gridview It is giving

The wait operation timed out .

 

So, we made

cmd.CommandTimeout = 1000;

After the above change we are able to display records, but it takes 2 minutes time. 
But beacuse of this small change we need to go for a release.
Any alternate way is there without making changes in c# code. 
 
 So can anyone share your answers so that can we made change in select query which prevent this The wait operation timed out
 
 
Thanks,
 
Vamsi 
Answers (1)