Menu
It is a performance question - I created a web app (in Node.js) that loads a JSON file that has around 10 000 records and then displays that data to the user. I'm wondering if it would be faster to use (for example) MongoDB(or any other noSQL database, CouchDB?) instead? And how much faster would it be?
230
asked Mar 30 '17 10:03
Open the Import Wizard. Then, choose JSON as the import format and click OK. Click on + to add JSON source documents, – to remove them, or the clipboard icon to paste JSON data from the clipboard. Here we will add the JSON source document, Rainfall-Data.
The best database for JSON This makes the MongoDB database the best natural fit for storing JSON data. You can store details of an entire object in one document, making it easier to view and query. MongoDB is the most popular JSON database as it offers many other benefits, like: Flexible schema.
Native JSON Data Stores do not always have the Best Performance. One of the best things about NoSQL database management systems is their performance. Since they work with simpler data structures than SQL databases, storage and retrieval tend to be faster in NoSQL database systems.
If you are looking for speed, JSON is quite specifically "not-fast". JSON involves sending the Keys along with the Values and it requires some heavy parsing on the receiving end. Reading the data from file can be slower than reading from the DB. I wouldn't like to say which is better, so you'll have to test it.
141
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
