Developer forum

Forum » Integration » Avoid lock of tables

Avoid lock of tables

E-mail notifications
Anders Ebdrup
Reply
Posted on 26/08/2016 13:48:16

Hi Dynmaicweb,

 

Will it possible to do database updates in the Data Integrations tools without locking the tables? E.g. setting some database hints? https://www.mssqltips.com/sqlservertip/3172/avoid-using-nolock-on-sql-server-update-and-delete-statements/

 

We have some solutions with heavy data load and experiences quote ofte sql timeouts due to the data integration locking the tables.

 

Best regards, Anders

 


Replies

 
Jonas Krarup Dam
Posted on 31/08/2016 09:30:47
Reply

Hi Anders,

I'm a bit confused - the link you include strongly recommends against using NOLOCK on inserts and updates.

How much data are you importing into dynamicweb, and how often?

We cannot avoid some locking, as long as we wish for data integration activities to be transactional.

Without knowing your specific case, it's hard to say for sure, but if you are importing large amounts of data often, I suspect that a lot of it may not change between imports. If this is causing you problems, you might want to look at incremental updates, and only updating changed data.

If I'm misunderstanding your problem completely, please feel free to write back (as I'm sure you will :-) )

 

/Jonas

 

You must be logged in to post in the forum