DbForge compare performance
DbForge compare performance
Compares against two large Oracle tables of 5 to 10 MB takes an hour sometimes many hours to Complete. What resources or techniques do you suggest to make the comparison run faster?
Re: DbForge compare performance
You can exclude records from comparison using the 'WHERE Filter' dialog box that can be invoked by clicking the 'Filter...' button on the 'Mapping' page of the 'New Data Comparison' wizard. Please also see the following topic in the product's Help documentation
http://www.devart.com/dbforge/oracle/da ... og_box.htm
Also, you can use the 'Custom Query' functionality. Please refer to the following topic http://www.devart.com/dbforge/oracle/da ... og_box.htm
http://www.devart.com/dbforge/oracle/da ... og_box.htm
Also, you can use the 'Custom Query' functionality. Please refer to the following topic http://www.devart.com/dbforge/oracle/da ... og_box.htm