Do I need to implement locking 1

[AP81]

Just a quick question:

I have an app I have written in Delphi which will eventually have up to 30 concurrent users. Do I need to implement my own read and write locks, or does MySQL take care of this? What about commiting queries?

Thanks in advance.




------------------------------------
There's no place like 127.0.0.1
------------------------------------

 

[TonyGroves]

If an entire operation is contained in a single SQL statement, then you don't need to use any form of locking; MySQL will ensure that there are no clashes.

However, if you need to ensure that two or more separate statements are run immediately after each other, you will need to use either table locking, or the transaction-processing features (BEGIN, COMMIT, etc.) of InnoDB tables.

 

[AP81]

Thanks!




------------------------------------
There's no place like 127.0.0.1
------------------------------------