sync db when the source ha highly usage
Posted: Thu 22 Apr 2021 09:35
I am wondering if this tool is the right tool for my needs and i hope this is the place to ask.
I plan to run a compare every few minutes while one of the tables at my source db is a table with over 30 millions records.
Every minute this table get bigger by at least 300 records.
The target db is a lazy db it is not going to be updated beside the sync process.
So my questions are:
1 - Is that the right tool for the job?
2 - How does the sync process works, I have seen that the first compare taking me around one hour, what happened at the source? does the db get locked? (i think that i have seen that the insert jobs are getting idle).
3 - What will happened in the other compares are they going to be shorter?
Hope to find that this tool is the right one for my usage.
Thanks.
I plan to run a compare every few minutes while one of the tables at my source db is a table with over 30 millions records.
Every minute this table get bigger by at least 300 records.
The target db is a lazy db it is not going to be updated beside the sync process.
So my questions are:
1 - Is that the right tool for the job?
2 - How does the sync process works, I have seen that the first compare taking me around one hour, what happened at the source? does the db get locked? (i think that i have seen that the insert jobs are getting idle).
3 - What will happened in the other compares are they going to be shorter?
Hope to find that this tool is the right one for my usage.
Thanks.