RohitPatel9999 <rohitpatel9999-/[EMAIL PROTECTED]>
wrote:
As I understand, it means after issuing BEGIN IMMIDIATE for read-only
SELECT(s), no other process can do BEGIN IMMIDIATE even if its for
read-only purpose. Even new reader will be blocked if it tries to do
BEGIN IMMEDIATE.
Right. Readers aren't supposed to do BEGIN IMMEDIATE - it's pointless
and harmful. Writers may, but don't really have to either.
If this is correct, for multiple SELECT statements (read-only, no
plan to write),
Which one is preferable -> BEGIN TRANSACTION or BEGIN IMMEDIATE ?
BEGIN TRANSACTION
Igor Tandetnik