The latest articles on DEV Community by alan2001-d (@alan2001d). https://dev.to/alan2001d https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F297525%2F192d08a7-eecb-44cc-bb98-d2652619df43.png https://dev.to/alan2001d en alan2001-d Fri, 20 Dec 2019 18:02:05 +0000 https://dev.to/alan2001d/most-performant-db-for-crud-app-39n4 https://dev.to/alan2001d/most-performant-db-for-crud-app-39n4 <p>I'm looking into creating a CRUD app that handles around ~100k of rows which can go bigger and has some API Calls that runs on that data. I will be doing many SELECT/UPDATE/DELETE/INSERT over this data which contain webpages text that are long.</p> <p>Also there would be there another table for logs which gonna be big (has long text of around 300-400 character).</p> <p>When to consider using MySQL over MongoDB or Elasticsearch and vice versa, I searched on google and saw benchmarks showing that MySQL is faster than MongoDB in select/update/insert/delete queries (1k/10k/100k rows) which is kinda confusing as MongoDB is being stated that its better when data grows bigger, I haven't used MongoDB or Elasticsearch before just MySQL.</p> <p>I would appreciate your help so much.</p> <p><a href="https://github.com/webcaetano/mongo-mysql">Benchmark</a></p> mysql mongodb architecture redis