Subject | Re: [firebird-support] Locking and disk activity |
---|---|
Author | Ivan Prenosil |
Post date | 2005-02-11T21:38:49Z |
>> i use statements like this to lock the rows I need:Yes, it will create new record version (unless the transaction
>> SELECT mycolumns FROM thetable WHERE thekey=? FOR LOCK
>>
>> do such locks involve WRITE disk activity (if I do not actually
>> modify the raw)?
is rolled back and cleans after itself).
>???
> Yes, but only if the page is in contention, which in turn depends on
> whether you're using SuperServer or Classic.
Ivan