Dear Basex,

Iam trying to create collection from json file,While creating the collection for 650 mb json file it is consuming more than 3gb of memory and getting out of memory exception.In case if I split the 650 mb json file into 10mb files and adding those files to collection it is adding but the time required to create the collection is around 6-7 mins.Could you please suggest how to create collection with less memory consumption and with high speed.

Also after creating collection tried writing query on collection which contains around 17lakh records the time for query execution is around 3 mins.Attached r the query and sample data.Please suggest is there anything wrong in my query to improve the performance.

Thanks & Regards

Sateesh.A