How is the performance of when we store data in JSON? Will it impact on creating the report from this JSON Column?

This is a common concern. It has been benchmarked and explained in detail here Please go through and let us know if you have further questions. Also, you havent mentioned about your reporting solution here. If It is PowerBI, you could read once, cache the dataset and improve performance in a big way. If this answers your query, please “Accept the answer” and Up-Vote for the same which might be beneficial to other community members reading this thread .

performance of JSON Column

Accepted answer

KalyanChanumolu-MSFT 8,346 Reputation points

2020-06-10T11:02:49.693+00:00

This is a common concern.
It has been benchmarked and explained in detail here

Please go through and let us know if you have further questions.

Also, you havent mentioned about your reporting solution here.
If It is PowerBI, you could read once, cache the dataset and improve performance in a big way.

If this answers your query, please “Accept the answer” and Up-Vote for the same which might be beneficial to other community members reading this thread .
Please sign in to rate this answer.
KalyanChanumolu-MSFT 8,346 Reputation points

2020-06-12T05:55:16.89+00:00

@KumariHemlata-2949 Just checking in to see if the above answer(s) helped.

If this answers your query, please “Accept the answe” and Up-Vote for the same which might be beneficial to other community members reading this thread . And, if you have any further queries do let us know.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

performance of JSON Column

0 additional answers

Your answer