Hi Geert,

I need all 30k results and since the response is in json array, I convert
it into a map first then each map goes through some data enrichment to
finally generate an html table.
Could I useany other search api ?

Thanks
Shruti
On 6 Jul 2015 01:50, "Geert Josten" <geert.jos...@marklogic.com> wrote:

>  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 <shrutikapoor....@gmail.com>
> Reply-To: MarkLogic Developer Discussion <general@developer.marklogic.com>
> Date: Sunday, July 5, 2015 at 11:22 AM
> To: MarkLogic Developer Discussion <general@developer.marklogic.com>
> 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
> General@developer.marklogic.com
> Manage your subscription at:
> http://developer.marklogic.com/mailman/listinfo/general
>
>
_______________________________________________
General mailing list
General@developer.marklogic.com
Manage your subscription at: 
http://developer.marklogic.com/mailman/listinfo/general

Reply via email to