Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AdamWest
Constraint Violating Yak Guru
360 Posts |
 Posted - 2010-05-08 : 23:25:35
|
| We have an app that sits on the server by itself, it gets the data daily at 6am. If a user would want to see the data in the app, we would have to run the refresh process which takes 30 min. We are not a 24/7 company. When the refresh runs during business hours the app does not work. THis scenario has only happened when a serious data entry error was discovered however I feel that should the need arise we should offer better than the 30 min wait.Suppose I want a faster turnover.I see 2 options, perhaps there are others.1. When doing a refresh, only send over the changes since the last time. Or this can be a special run. Maybe do the complete refresh at 6am, then do the changes refresh upon request. 2. Create a paralell database that is constantly receiving the data from the production system. WHen the user requests the latest,either setup a second program for this purpose that points to the paralell database or have code in the existing to allow for this.I am interested in hearing others opinions about this entire process. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-05-09 : 02:55:04
|
| i think 1 seems to be a good approach. setting a parallel database requires some serious thoughts on what all entities (table) that you need to keep and also what all referential integrity you want to maintain, business rules etc------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
AdamWest
Constraint Violating Yak Guru
360 Posts |
Posted - 2010-05-09 : 11:14:00
|
| Good point Visakh, I forgot to mention an important consideration.There is some redundancy in several columns, that are long, such as Item Desrciption. We can also just take the fields we want. Although this effort would be considered regardless of the current issue. |
|
|
|
|
|
|
Replication constant question