Database Synchrinization

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.

Thanks.