Query processing

Question

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