weeklydeals:
Please read the question, it had/has nothing to do with performance.
However, to address that issue, as it can be a concern:
You will find that perfomance has much do with the hardware and the database design. On several of my splits, I have over 60 concurrent on a LAN without issues and it is mainly due to how the frontend/backend are designed, the highspeed backbone, and using the most up to date OS/Hardware configurations - and yes, I had help from professionals to streamline things on the software side.
Frankly, often our MYSQL and SQLServers are often much slower despite being on the same backbone and hardware (sometimes even with fewer users; however, that's a rare event :) ). The programmers admit that it has to do with the overall design of the databases and the need to work with legacy record systems.
rahul2310:
Record locking issues can not be easily predicted without know your database. It happens when two or more users access the same record(s) for create/write/modification at the same time in the same table. If you want more detail, then please start a new thread (^-^).