How do you handle record locking in a flex (flash builder 4) application with multiple users? It is using zend amf to talk to a database (mongodb or mysql).
I have the scenario like this, My environment is .Net2.0, VS 2008, Web Application I need to lock a record when two members are trying to access at the same time.
I\'m getting these about 5 times an hour in my slow query logs: # Query_time: 11.420629Lock_time: 0.000033 Rows_sent: 0Rows_examined: 0
In the application that I\'m currently working on, it is possible for multiple users to want to edit something at the same time which means that we need to implement optimistic locking. However, for t