Ellen Hu

Ellen Hu

  • NA
  • 63
  • 0

How should data be updated? Or how to "Caching" data to avoid constantly request at sql server?

Oct 27 2011 12:16 AM
Hi All,

(I am not interested using caching at web page, and looking for database solution only)

There are many data needs to be displayed on the web page, like company total working hours (this is just an example, there are more data in fact), also for individuals can login and update their account through web page, say report working hour.

After an individual added some hours, the total hours for this individual and whole company will be changed accordingly.
 
The totals are calculated via a complicated stored procedue, having joined multi tables(the sp is also optimized), many users log into their accounts might at almost same time.

Question: 
Is it good idea to create a table to hold such totals, and this table will be updated only at midnght through scheduled job?

In that case could avoid to calling those complicated stored procedures, in order to gain performance?

or there are some other approaches?

Thank you for your time to looking this thread.

ellem



Answers (6)