Hi Shruti, I think that you will find that if you wrap the cts:value-tuples in a count that it will run much faster, maybe even in sub-sec. Most time is consumed by serializing 30k json arrays. Do you really need all 30k items, or would top 20 be sufficient?
Cheers, Geert From: shruti kapoor <[email protected]<mailto:[email protected]>> Reply-To: MarkLogic Developer Discussion <[email protected]<mailto:[email protected]>> Date: Sunday, July 5, 2015 at 11:22 AM To: MarkLogic Developer Discussion <[email protected]<mailto:[email protected]>> Subject: [MarkLogic Dev General] Reduce the query execution time for cts:value-tuples Hi, I have a cts:value-tuples() query which fetches the json array result. The query runs on aprroximately 3lac xmls and the result set contains about 30k elements in json array. It takes about 48sec to run this query. Is there a way to reduce its execution time. I have used range indexes for references and even enabled "concurrent". -- Regards, Shruti Kapoor
_______________________________________________ General mailing list [email protected] Manage your subscription at: http://developer.marklogic.com/mailman/listinfo/general
