Query processing

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