Subject Lock Manager in Firebird 1.5.2

We are facing problems with locking of pages / tables.

The problem is as follows:

1) Multiple processes (for per user) are writing / reading records
to / from a table. Each user is working on her set of records so they
are working on a different rows altogether.

2) If a single user takes 5 seconds to complete a transaction,
then 3 users take nearly 5x3 = 15 seconds when the transaction is run

3) It is as if the next thread is waiting for the page lock to be
released by the previous thread. The results look linear when multiple
users are run concurrently.

4) What kinds of settings are required to overcome this problem?

5) We are using Super Server.

Please help.

Thanks and Regards,


Project Leader - Investment Banking Group

PrimeSourcing(tm) "Add Value Reduce Risk"

i-flex solutions ltd., Mumbai

Tel Office: +91-22-5642-7144

e-mail: hemant.sapre@...

This message contains privileged and confidential information and is intended only for the individual named.If you are not the intended recipient you should not disseminate,distribute,store,print, copy or deliver this message.Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted,corrupted,lost,destroyed,arrive late or incomplete or contain viruses.The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version.

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