Page 1 of 1
DbForge compare performance
Posted: Fri 20 Feb 2015 17:13
by dnjwms
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
Posted: Mon 23 Feb 2015 09:16
by alexa
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