About MsSQL I have done some test on MsSQL with SymmetricDS, and I run into a problem with batch operation on database table. For example, inserting 300000 rows takes about 1-2s with disabled SymmetricDS triggers, and about 20-25s when triggers are enabled. Is this a normal situation?
I have huge database (about 100gb size) of which I want to do slave readonly instance using SymmetricDS. What is the best way of doing initial load? Inital load using SymmetricDS last too long. I thought about manually restoring db on slave machine, but what about the data changed in master db while slave is restoring?