期望:
想实现类似如下sql查询:select sum(col) from xxx where a=? and b=? and c=? and d in();
现状和问题:
目前查到的资料是使用mongodb的mapreduce和group by的查询。
但是当数据量过百万的时候,查询速度就巨慢。
求教:
慢得原因是否和group/mapreduce的查询方式有关?
mongodb能实现我期望的查询形式吗?
有何优化方案吗?
...全文
164819打赏收藏
请教关于mongodb聚合查询优化问题
期望: 想实现类似如下sql查询:select sum(col) from xxx where a=? and b=? and c=? and d in(); 现状和问题: 目前查到的资料是使用mongodb的mapreduce和group by的查询。 但是当数据量过百万的时候,查询速度就巨慢。 求教: 慢得原因是否和group/mapreduce的查询方式有关? mongodb能实现我期望的查询形式吗? 有何优化方案吗?
are u an employee of mongodb?[/quote]
HI
nope.
哈哈,不是的。是Mongodb中文文档翻译组的成员。[/quote]
that's pretty cool! I guess I will probably have lots of questions for u, so thank you in advance!
BTW, "Mongodb中文文档翻译组", is this a paid job or a voluntary effort?[/quote]
It`s just a a voluntary effort.
And u can get more information from the mongoing.com.
[/quote]
the website looks great! keep your good work and I am sure you will meet mongo users worldwide soon in the States![/quote]
lol~[/quote]
I am not kidding, u guys deserve it...
I will be very disappointed if mongo doesn't offer it...[/quote]
我也希望呀~嘿嘿,借你吉言啦~
目前我是打算先把上海用户组多多推广~
人数够的时候,在上海组织次交流会嘛,请TJ哥来分享分享,自己也做点分享什么的~
[/quote]
who's TJ?
Does Mongo have an office in mainland China?[/quote]
TJ 是MongoDB官方在大中华区的首席技术顾问,他的职责是为MongoDB的用户提供方案架构,性能优化,系统部署及扩展等方面的技术支持。在加入MongoDB之前, TJ在联邦快递新加坡担任首席技术架构师。
有的,应该是在深圳~[/quote]
Great!
looking forward to seeing his presentation![/quote]
我也很期待啊~
are u an employee of mongodb?[/quote]
HI
nope.
哈哈,不是的。是Mongodb中文文档翻译组的成员。[/quote]
that's pretty cool! I guess I will probably have lots of questions for u, so thank you in advance!
BTW, "Mongodb中文文档翻译组", is this a paid job or a voluntary effort?[/quote]
It`s just a a voluntary effort.
And u can get more information from the mongoing.com.
[/quote]
the website looks great! keep your good work and I am sure you will meet mongo users worldwide soon in the States![/quote]
lol~[/quote]
I am not kidding, u guys deserve it...
I will be very disappointed if mongo doesn't offer it...[/quote]
我也希望呀~嘿嘿,借你吉言啦~
目前我是打算先把上海用户组多多推广~
人数够的时候,在上海组织次交流会嘛,请TJ哥来分享分享,自己也做点分享什么的~
[/quote]
who's TJ?
Does Mongo have an office in mainland China?[/quote]
TJ 是MongoDB官方在大中华区的首席技术顾问,他的职责是为MongoDB的用户提供方案架构,性能优化,系统部署及扩展等方面的技术支持。在加入MongoDB之前, TJ在联邦快递新加坡担任首席技术架构师。
有的,应该是在深圳~[/quote]
Great!
looking forward to seeing his presentation!
are u an employee of mongodb?[/quote]
HI
nope.
哈哈,不是的。是Mongodb中文文档翻译组的成员。[/quote]
that's pretty cool! I guess I will probably have lots of questions for u, so thank you in advance!
BTW, "Mongodb中文文档翻译组", is this a paid job or a voluntary effort?[/quote]
It`s just a a voluntary effort.
And u can get more information from the mongoing.com.
[/quote]
the website looks great! keep your good work and I am sure you will meet mongo users worldwide soon in the States![/quote]
lol~[/quote]
I am not kidding, u guys deserve it...
I will be very disappointed if mongo doesn't offer it...[/quote]
我也希望呀~嘿嘿,借你吉言啦~
目前我是打算先把上海用户组多多推广~
人数够的时候,在上海组织次交流会嘛,请TJ哥来分享分享,自己也做点分享什么的~
[/quote]
who's TJ?
Does Mongo have an office in mainland China?[/quote]
TJ 是MongoDB官方在大中华区的首席技术顾问,他的职责是为MongoDB的用户提供方案架构,性能优化,系统部署及扩展等方面的技术支持。在加入MongoDB之前, TJ在联邦快递新加坡担任首席技术架构师。
有的,应该是在深圳~
are u an employee of mongodb?[/quote]
HI
nope.
哈哈,不是的。是Mongodb中文文档翻译组的成员。[/quote]
that's pretty cool! I guess I will probably have lots of questions for u, so thank you in advance!
BTW, "Mongodb中文文档翻译组", is this a paid job or a voluntary effort?[/quote]
It`s just a a voluntary effort.
And u can get more information from the mongoing.com.
[/quote]
the website looks great! keep your good work and I am sure you will meet mongo users worldwide soon in the States![/quote]
lol~[/quote]
I am not kidding, u guys deserve it...
I will be very disappointed if mongo doesn't offer it...[/quote]
我也希望呀~嘿嘿,借你吉言啦~
目前我是打算先把上海用户组多多推广~
人数够的时候,在上海组织次交流会嘛,请TJ哥来分享分享,自己也做点分享什么的~
[/quote]
who's TJ?
Does Mongo have an office in mainland China?
are u an employee of mongodb?[/quote]
HI
nope.
哈哈,不是的。是Mongodb中文文档翻译组的成员。[/quote]
that's pretty cool! I guess I will probably have lots of questions for u, so thank you in advance!
BTW, "Mongodb中文文档翻译组", is this a paid job or a voluntary effort?[/quote]
It`s just a a voluntary effort.
And u can get more information from the mongoing.com.
[/quote]
the website looks great! keep your good work and I am sure you will meet mongo users worldwide soon in the States![/quote]
lol~[/quote]
I am not kidding, u guys deserve it...
I will be very disappointed if mongo doesn't offer it...[/quote]
我也希望呀~嘿嘿,借你吉言啦~
目前我是打算先把上海用户组多多推广~
人数够的时候,在上海组织次交流会嘛,请TJ哥来分享分享,自己也做点分享什么的~
are u an employee of mongodb?[/quote]
HI
nope.
哈哈,不是的。是Mongodb中文文档翻译组的成员。[/quote]
that's pretty cool! I guess I will probably have lots of questions for u, so thank you in advance!
BTW, "Mongodb中文文档翻译组", is this a paid job or a voluntary effort?[/quote]
It`s just a a voluntary effort.
And u can get more information from the mongoing.com.
[/quote]
the website looks great! keep your good work and I am sure you will meet mongo users worldwide soon in the States![/quote]
lol~[/quote]
I am not kidding, u guys deserve it...
I will be very disappointed if mongo doesn't offer it...
are u an employee of mongodb?[/quote]
HI
nope.
哈哈,不是的。是Mongodb中文文档翻译组的成员。[/quote]
that's pretty cool! I guess I will probably have lots of questions for u, so thank you in advance!
BTW, "Mongodb中文文档翻译组", is this a paid job or a voluntary effort?[/quote]
It`s just a a voluntary effort.
And u can get more information from the mongoing.com.
[/quote]
the website looks great! keep your good work and I am sure you will meet mongo users worldwide soon in the States![/quote]
lol~
are u an employee of mongodb?[/quote]
HI
nope.
哈哈,不是的。是Mongodb中文文档翻译组的成员。[/quote]
that's pretty cool! I guess I will probably have lots of questions for u, so thank you in advance!
BTW, "Mongodb中文文档翻译组", is this a paid job or a voluntary effort?[/quote]
It`s just a a voluntary effort.
And u can get more information from the mongoing.com.
[/quote]
the website looks great! keep your good work and I am sure you will meet mongo users worldwide soon in the States!
are u an employee of mongodb?[/quote]
HI
nope.
哈哈,不是的。是Mongodb中文文档翻译组的成员。[/quote]
that's pretty cool! I guess I will probably have lots of questions for u, so thank you in advance!
BTW, "Mongodb中文文档翻译组", is this a paid job or a voluntary effort?[/quote]
It`s just a a voluntary effort.
And u can get more information from the mongoing.com.
are u an employee of mongodb?[/quote]
HI
nope.
哈哈,不是的。是Mongodb中文文档翻译组的成员。[/quote]
that's pretty cool! I guess I will probably have lots of questions for u, so thank you in advance!
BTW, "Mongodb中文文档翻译组", is this a paid job or a voluntary effort?