As Volker states (correctly), at isolation level 0 connections will still block on other connections due to write or intent lock conflicts. At isolation level 0, SQL Anywhere connections do not acquire read locks on rows. Other types of row locks (INTENT, WRITE) are, however, still acquired and may cause blocking. Schema locks and table-level locks also still apply to isolation level zero connections. answered 13 Feb '12, 13:37 Glenn Paulley 1
... but would that block a connection that is "executing a simple select on the table"?
(13 Feb '12, 18:10)
John Smirnios
|
if you don't want to lock rows, do a commit after the select. we have a PowerBuilder app with 50+ windows and 200+ datawindows. to avoid the locking problem, after each dw retrieve, that we won't update, we do a commit. answered 14 Feb '12, 06:50 Tom Mangano |
Writers do always block writers, regardless of isolation levels...but that do not seem to be your case, right?
You are so quick ;-) You mean a writer which have not already issued its commit will block other writers?
Well, the "quickness" may be due to the fact that on this forum, "writers do not block writers" - though they (at least me) sometimes skip the "thoroughly reading" (or "fully understanding") part:)