i have json string its size is 1.45MB.
i m using this string in openjason to select data from json string.
when i am running query with select statement its taking 5 to 10 minutes time on test environment server.
same thing am running in local sql server its give me result in 200ms.
i tried all , increase size of tempdb, clear cache, shring file,clear all log files too.
please help me here what i am missing .
what should i have to take care to improve this execution.