The wait operation timed out

Question

Hi All,

 When we are getting data from backend to front end we are facing the error "The wait operation timed out" Most of the authors are saying add CommandTimeout= 1000 so that problem will solve.

 

Any other ideas please. because  with in that 1000 seconds if execution not happened then again error will come.

 

Top 100 Records we are fetching from sql view . That view contains  lakhs of  records.

 

Thanks,

Vamsi