DbForge compare performance

DbForge compare performance

Postby 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?
dnjwms
 
Posts: 3
Joined: Fri 20 Feb 2015 16:31

Re: DbForge compare performance

Postby 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/datacompare/docs/index.html?where_filter_dialog_box.htm

Also, you can use the 'Custom Query' functionality. Please refer to the following topic http://www.devart.com/dbforge/oracle/datacompare/docs/index.html?custom_query_mapping_dialog_box.htm
alexa
Devart Team
 
Posts: 2175
Joined: Fri 24 Jun 2011 14:17


Return to dbForge for Oracle