> We're having slow performance in pessimistic lock in Firebird 1.5.4.4910
> 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 ?

Ivan