General information
Forum:
Microsoft SQL Server
Thanks Mike. I appreaciate the feedback.
I get used to doing things in a certain way for VFP, then switch to SQL and I'm wondering if i'm missing something somewhere.
Setting the flag looks like the way I'll be going.
Take care,
Anthony
>I have never been a fan of solutions that rely on pessimistic locking. They always seem to lead to concurrency issues and performance problems.
>
>Remember that SQL Server uses locks when it's reading data so if you were to set your isolation level to REPEATABLE READ or SERIALIZABLE, you'd be holding the SELECT locks on rows and index keys until the transaction terminates. This is probably the problem that you're seeing in your testing.
>
>Would it be possible to process the data in blocks of rows instead of a single row? Fall back to the idea of creating a flag in the row. "Lock" the rows by setting the flag and then return them to the client. Let the client do the calculations for each row and then write all the updates to all rows. Then release the "lock."
>
>-Mike
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only