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