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.

I thought that parameter is valid for classic server, so I am wondering if
this behavior could be a bug.



My server is windows 2000 with 2 xeon processors.



Thanks,



Elkins



[Non-text portions of this message have been removed]