Subject Re: [firebird-support] Slow performance in pessimistic lock
Author Ivan Prenosil
> We're having slow performance in pessimistic lock in Firebird
> Superserver with a query like 'select field from table where id = 99 with
> lock'.
> This query used to work find in Firebird 1.5.3, so I checked the
> configuration file and activated the LockAcquireSpins = 0 and then things
> get back to normality.

But zero is default value for that parameter, so you actually did not change anything ...
Or did you change anything else ?