How efficient is using JSON with MySQL? (esp. JSON_EXTRACT, JSON_MERGE..)

Question

I am used to MSSQL, now using MySQL, and have come to a point, where it is convenient to dump a whole JSON object into a single db column, instead of hacking it away into separate ones, in a relational database fashion. Most of the time, I will just SELECT the whole object back into the app when needed, but occasionally, I will want to filter rows according to contents of the JSONs and maybe do some other operations.

Is working with JSON objects "native" to MySQL, or is it kinda hammered it, for extended usability (JSON_EXTRACT, JSON_MERGE..), while sacrificing performance, and therefore not a good way to go?

Ganesh Chandrasekaran · Accepted Answer · 2019-05-07 01:22:54Z

1

Its native to MySQL and works very smooth.

Read through this example.. its pretty simple and useful

https://scotch.io/tutorials/working-with-json-in-mysql

answered May 7, 2019 at 1:22

Ganesh Chandrasekaran

1,96614 silver badges20 bronze badges

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

2 Comments

marko-36 Over a year ago

I actually wrote this question while going through that tutorial :) Any stats on how it performs compared to standard non-JSON CRUD?

Ganesh Chandrasekaran Over a year ago

I don't see any difference with millions of rows on 2 level JSON objects. I love the combination of RDBMS with JSON flexibility though.

Collectives™ on Stack Overflow

How efficient is using JSON with MySQL? (esp. JSON_EXTRACT, JSON_MERGE..)

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