Can multiple users insert into a server database simultaneously?

Question

I have a MySQL database on my server, and a Windows WPF application from which my clients will be inserting and deleting rows corresponding to their data. There may be hundreds of users working on the application at the same time, and they will be inserting or deleting rows in the db.

My question is whether or not all the database execution can go successfully or should I adapt some other alternative?

PS: There won't be any clash on rows while insertion/deletion by users as a user will be able to add/remove his/her corresponding data only.

It depends on how did you implement your application – Pavel Anikhouski May 18 '20 at 14:21 — Pavel Anikhouski, May 18 '20 at 14:21
Of course. That's one of the reasons you use a database. – Robert Harvey May 18 '20 at 14:21 — Robert Harvey, May 18 '20 at 14:21

score 0 · Accepted Answer · answered May 18 '20 at 14:29

My question is whether or not all the database execution can go successfully ...

Yes, like most other relational database systems, MySQL supports concurrent inserts, updates and deletes so this shouldn't be an issue provided that the operations don't conflict with each other.

If they do, you need to find a way to manage concurrency.

MySQL concurrency, how does it work and do I need to handle it in my application

Can multiple users insert into a server database simultaneously?

1 Answers1