Hi,

Thanks for your reply. I confirm, a large volumes of JSON in a given column is stored in our Database. We are already thinking to re-write the JSON...

I think so too, but it's another entreprise who did the developpment, now we have to find a way to optimize this application.

Thanks for your solution. The developer is using substring function in sql to solve this case but it's too slow so we are testing to use JSON functions. We thought...