Q:

What is faster to insert, update or delete MongoDB or SQL?

I am deciding between using MongoDB and MySQL for my next application. I'll use Elasticsearch for search queries so I don't care about this.
So in these 3 operations: insert, update and delete. Which one is faster, MongoDB or SQL?
Thanks.

A:

If you are inserting/updating/deleting an object, like a customer or order, then I would assume it would be slower to do it via SQL because that data would typically be normalized so you would need to split that object into it's normalized forms to insert.
The real answer is to load test the different tools based on your needs and see which works out for you but I suspect that either one will work well for you unless you're dealing with big, big data.

