All geek questions in one place

Storing a single column in a NoSQL database?

In the application I'm working on, we use the MySQL database and want to store the articles in a table. Instead of storing them in SQL DB, we considered only storing the key to the article in the NoSQL database. Is this a good problem to solve the problem using NoSQL, or will we just create another table in MySQL and save large amounts of text there?

We use MongoDB to store text.

+3
source share
2 answers

The first thing I would do is to test how MySQL works with "lots of data." If you get acceptable performance, then it makes no sense to try to make the system more complex.

Putting text content in a separate table in MySQL would not bring anything. Including it in a separate help may , but I would not do it if you are not sure that MySQL is a significant bottleneck and that you cannot do anything, such as optimizing your queries.

+1
source

MongoDB is good for storing large blob-ish fields, whether textual or binary. Therefore, I think this is good.

BSON ( MongoDB ") 4 . 4 , GridFS, .

0

Source: https://habr.com/ru/post/1749987/

More articles:


All Articles