Account Options

  1. Sign in
The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Google Groups Home
« Groups Home
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. &nbsp;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--