Transaction Recording / Recovery

[plehry]

I was asked a question today by our developers in regards to how Sugar handles transaction recording and recovery.

The main issue is that if during a record update, the connection is lost due to a power outage or a lost connection with the web server, how does Sugar and/or MySQL handle recovery? If two people are making a change to a record and one of them loses the connection, how does the software recover?

Thanks in advance.

[Angel]

I am not aware of anything within the Sugar code that utilizes transactions. Sugar is rather simplistic in this regard and just hands off the INSERT/UPDATE/DELETE query to PHP which in turn talks to MySQL to execute it.

Anything transaction related would have to be performed at the SQL server level.

This might help further answer your questions: http://dev.mysql.com/doc/refman/5.0/...nsactions.html

[crmsiva]

Me too had similar doubts. What happens if more than one user is trying to update a single record at the same time?