question

KumariHemlata-2949 avatar image
0 Votes"
KumariHemlata-2949 asked ·

performance of JSON Column

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

azure-sql-database
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

KalyanChanumolu-MSFT avatar image
0 Votes"
KalyanChanumolu-MSFT answered ·

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 .

· 1 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@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. 


0 Votes 0 ·