I have joined three tables from oracle DB and projected two columns in each table. Now I tried to expose this as a JSON REST service endspoint.
I have modified the output JSON structure, From the flattern view to JSON Array. Something like below.
I did this using this VQL - select key1, nest(subkey1, subkey2....) as arr from baseview;
After I did this struture modification, the resultset output is very slow it takes more than 3 minutes.
So, How to modify the json structure without affecting the response time? Please help.