DbForge compare performance

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
dnjwms
Posts: 3
Joined: Fri 20 Feb 2015 16:31

DbForge compare performance

Post by dnjwms » Fri 20 Feb 2015 17:13

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?

alexa
Devart Team
Posts: 2430
Joined: Fri 24 Jun 2011 14:17

Re: DbForge compare performance

Post by alexa » Mon 23 Feb 2015 09:16

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

Post Reply