a large software project ground to halt when first usage tests with multiple users were made. the database queries and the transaction locking lead to strong interferences effectively rendering the software useless for the planned hundreds of users.

the analysis of database optimizations and transaction locking behaviour led to a catalogue of suggestions to resolve most of the problems.

the project was challenge with little cooperation by the development team.