General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2003 Server
I said "what I am looking for is some consistency". Maybe a better word is "opredelennost'". How do you say it in English? Determination?
Still, this is inconsistent to me:
"Filter" condition only tries to lock records if they are "suspect" based on their "last known" state. "Join" condition locks records even to *see* if they are suspect.
"Filter" condition is re-applied after a record is locked. "Join" condition is not.
This is affecting my program performance and even outcome. And I didn't want to see a difference between join and filter in the first place.
Wouldn't having isolation levels help determine what developer really wants without making assumptions on his behalf?
-Andrew
Previous
Next
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