Record locking during the porting of data

[Pradeep Mathew]

When I am extracting the data from one or more tables in a database and updating the consolidated value to other database, the source database transactions are getting hang. Is it advisable to make view file for the source database and whether it will affect any performance.

Regards

Pradeep

 

[Peter Schmitz]

If it would be acceptable to retreieve data that has not yet been committed, you might see a performance benefit from using a NOLOCK index hint.

Another option could be to better optimize the indexes on your source database/tables, or taking a snapshot or backup of the database for loading.