This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi, We're currently considering Lightspeed as our new datalayer-framework. Now, we're using a combination of ADO.NET Datasets and Entity Framework. Today, we ran into a problem with these. We have 2 databases, that need to stay in sync (the scheme is different). So we're created a program with EF that keeps the 2 in touch. Now, 2 customers need to use the 2nd database. So the sync is required. The first time we run this thing... It needs to transfer for example + 200 000 contacts. If we run our program, it locks system 1 down, because there is no such thing as WITH (NOLOCK) in EF. Is this NOLOCK feature possible in LightSpeed? I've seen an old post where that wasn't possible, but maybe it is right now? Thank you |
|
|
|
|
Yes, you can do this using the WithTableHint() operator. See http://www.mindscapehq.com/documentation/lightspeed/Performance-and-Tuning/Database-Hints for the details. |
|
|
|
