Storing in a JSON file vs. JSON object vs. MYSQL database

Question

I've programmed a chat application using nodejs, expressjs and socket.io. So, When I used MYSQL database the application slows down then I replaced it with storing the data using JSON objects (in the server-side of nodejs).

Now everything is ok and the application is working well, but If I want to release an update of the nodejs' app.js file it should be restarted, so, everything in the JSON objects will be deleted!

How can I fix this problem? and can I store in a JSON file to fix it? and will the application stay at the same speed or what?

@yashpandey Yes, that's right, my application is a runtime chat, I don't want to use MYSQL because it will be the same (slow), My answer is about the speed of JSON object storing speed and JSON file storing speed! — Ghadeer R. Majeed
– Ghadeer R. Majeed, Commented Mar 7, 2018 at 16:15

Alexandru Olaru · Accepted Answer · 2018-03-07 15:32:19Z

2

Storing data in RAM will be always faster than writing to a database, but the problem in your case you need to persist it somewhere.

There are many solutions to this problem but if you are using JSON's, I recommend to look at mongodb database.

MongoDb supports multiple storage engines, but the one that you are interested is in memory.

An interesting architecture for you can be the following replica set configuration:

Primary with in-memory storage engine
Secondary with in-memory storage engine
An other Secondary with wiredtiger storage engine.

You will have the benefits of speed by storing in RAM, and also it will be persisted in the database.

A simpler possibility will be to use a key-store db like redis. Easier to configure.

answered Mar 7, 2018 at 15:32

Alexandru Olaru

7,1426 gold badges31 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ghadeer R. Majeed Over a year ago

I think that your answer as very useful and will solve the problem. But Mongodb is so hard to install and learn and I have wrote many lines of codes and it's so hard to change. Is there another way can help me please ?

user6249539 Over a year ago

you dont have to install mongo I suppose. you can use it on cloud - mlab.com. You can use that , they give 500 mb free and there is no hard learning curve in mongo

Collectives™ on Stack Overflow

Storing in a JSON file vs. JSON object vs. MYSQL database

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related