Queue implementation

Question

What is the best way to implement fast queue where multiple users try to access to about 100 000 records. Only one user can get one unique row. Now im using sql database (firebird) but there is a lot of problems deadlocks / high database load.

Answer 1

Most of the time, deadlocks are caused by bad transaction logic.

In general, the transactions have to be short (the shorter the better).

You can start by reading some doc:

http://www.firebirdsql.org/doc/whitepapers/fb_vs_ibm_vs_oracle.htm

http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_expert4