I'm working on a system that needs to manage databases for 1000 users (at maximum). I used Apache server, and MySQL for this task.
Since I'm new to the whole thing my question is:
- Is it possible to configure Apache server so it locks writing on a record whenever a user is updating that record?
- Is it the right choice? I mean is it better for me to implement my own server or just use Apache?
I'm using python 2.6 and Windows x64, pyqt4 for the interface.
I would really appreciate it if you guys could give me any advise related to this (like: Don't use python, use C++).