what will happened if i will call same function on two timer

Question

hello every one..  i have a question, what will happened if i will call same function say  getDetails() , which gives me details from database(SQL server 2008 R2).. this function is called on more than 5 timers, which are running simultaneously and created dynamically .. will it reduce my application performance ?? please help me..

Sanjay Sabariya · Answer

what you want from database and are you get this detail form multiple table. ? Please give me full details so i give u batter suggestion

madhuri Gamane · Answer

Details which i am getting from database on each timer's tick are changes conti neously other wise i may save that details in datatable

Sanjay Sabariya · Answer

yes it'is also reduce your application performance. b'coz your function every time to call database for same details. battery way is you can store this details in some temp storage like jstore.

madhuri Gamane · Answer

little confusion... its my mistake, it is a method of c# where i mentioned function sorry for that...  now here is my question   what will happened if i will call same method say getDetails() , which gives me details from database(SQL server 2008 R2).. this method is called on more than 5 timers, which are running simultaneously and created dynamically .. will it reduce my application performance ??

Sanjay Sabariya · Answer

yes it's reduce your application performance.     B'coz Function is compiled and executed every time when it is called.   so i think u use store procedure instead of function.    Refer the this link : http://www.c-sharpcorner.com/UploadFile/2072a9/store-procedure-vs-function-in-sql-server/