Message from discussion
Hinting aggregation or mapreduce operations?
Date: Thu, 8 Nov 2012 12:02:28 -0800 (PST)
From: Dwight Merriman <dwi...@10gen.com>
To: mongodb-user@googlegroups.com
Message-Id: <b9f4aaa8-4753-44ef-8a64-d25e49d9da8f@googlegroups.com>
In-Reply-To: <24c1e00d-8bfb-4e4e-bb93-ea528ca64a75@googlegroups.com>
References: <24c1e00d-8bfb-4e4e-bb93-ea528ca64a75@googlegroups.com>
Subject: Re: Hinting aggregation or mapreduce operations?
MIME-Version: 1.0
Content-Type: multipart/mixed;
boundary="----=_Part_146_22522308.1352404949079"
------=_Part_146_22522308.1352404949079
Content-Type: multipart/alternative;
boundary="----=_Part_147_12496510.1352404949084"
------=_Part_147_12496510.1352404949084
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
i think you can use $hint in your query expression you are doing with agg
framework and/or MR. maybe.
On Wednesday, November 7, 2012 10:15:30 AM UTC-5, Esteban Feldman wrote:
>
> Hi all.
>
> I'm performance tunning my application and found that some aggregation and
> mr operations take long time. So I try to .explain() the query for those
> operations and found that mongo doesn't choose wisely, if I hint at it it
> will be lot faster than the original (in 1 query from 16700ms to 29ms).
>
> So my question is if there is a way to give hint to aggregation and or MR
> operations?
>
> Thanks
>
------=_Part_147_12496510.1352404949084
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 7bit
i think you can use $hint in your query expression you are doing with agg framework and/or MR. maybe.<div><br></div><div><br><div><br></div><div><br><br>On Wednesday, November 7, 2012 10:15:30 AM UTC-5, Esteban Feldman wrote:<blockquote class="gmail_quote" style="margin: 0;margin-left: 0.8ex;border-left: 1px #ccc solid;padding-left: 1ex;">Hi all.<div><br></div><div>I'm performance tunning my application and found that some aggregation and mr operations take long time. So I try to .explain() the query for those operations and found that mongo doesn't choose wisely, if I hint at it it will be lot faster than the original (in 1 query from 16700ms to 29ms).</div><div><br></div><div>So my question is if there is a way to give hint to aggregation and or MR operations?</div><div><br></div><div>Thanks</div></blockquote></div></div>
------=_Part_147_12496510.1352404949084--
------=_Part_146_22522308.1352404949079--