Subject Slow performance in pessimistic lock
Author Elkins Villalona
We're having slow performance in pessimistic lock in Firebird
Superserver with a query like 'select field from table where id = 99 with

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.



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