Database Synchrinization

By syedalimurtuza ·
Hello all the database experts out there. I'm an entery level junior programmer assisting in web development. We use SQL server 2005 and Visual Studio 2005 as our development tools.

We continously synchronize the tables (main) with other small tables thoughout the day and night. The synchronization is done with a non-interactive VB app on the server.

Since we do changes in main table, the child talble needs to be updated regularly. We have a new web app running of the main and the child table. Since we started this new web app, we have noticed Data Latency on our apps. Is there any better way of synchronizing data tables without effecting the data performance. Please let me know.


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Database synchronization

by contactrakeshsingh In reply to Database Synchrinization

how are you maintaining the lock while updating the master database while any application is accessing it's data.

locking plays a vital role data latancy, if locking and freeing of the records are not done properly then it will result in latency of data. and will degrade the performance of your application.

Related Discussions

Related Forums