Faceted search with MongoDB Vs Solr/Elastic Search Combo

[Julius Somoye]

Hi,

I need some advice regarding faceted search in MongoDB. I currently
have around 100 milllion products in my collection. As you would
expect faceted search is very important for the front end search
implementation e.g. http://www.shopwindow.com/productlist.php?rb=4-6

I know MongoDB's map/reduce can offer aggregation/grouping for simple
facets. Having read a few articles online I have the sense that Mongo
is not designed to efficiently handle faceted search. Using map/reduce
for this carries a heavy performance hit from what I have come
across.

I am using the PHP driver. Does anyone know the best solution for
handling faceted search in MongoDB? Will it be better to use a search
engine for the search and MongoDB for CRUD?

Thanks

[Sam Millman]

"Will it be better to use a search
engine for the search and MongoDB for CRUD?"

Always but not many support realtime searching in mongo if any :(.

If this is not a problem to you I would always suggest using a specially
designed search tech like Solr or ElasticSearch etc etc.

Post by Julius Somoye
Hi,
I need some advice regarding faceted search in MongoDB. I currently
have around 100 milllion products in my collection. As you would
expect faceted search is very important for the front end search
implementation e.g. http://www.shopwindow.com/productlist.php?rb=4-6
I know MongoDB's map/reduce can offer aggregation/grouping for simple
facets. Having read a few articles online I have the sense that Mongo
is not designed to efficiently handle faceted search. Using map/reduce
for this carries a heavy performance hit from what I have come
across.
I am using the PHP driver. Does anyone know the best solution for
handling faceted search in MongoDB? Will it be better to use a search
engine for the search and MongoDB for CRUD?
Thanks
--
You received this message because you are subscribed to the Google Groups
"mongodb-user" group.
To unsubscribe from this group, send email to
For more options, visit this group at
http://groups.google.com/group/mongodb-user?hl=en.

[Julius Somoye]

Ok, Thanks Sam. I have played around with MongoDB mapReduce and it
seems to perform simple faceting considerably well. I wonder if anyone
has a more advanced usage for a proper faceted search. I would love to
keep everything Mongo if possible.

Post by Sam Millman
"Will it be better to use a search
engine for the search and MongoDB for CRUD?"
Always but not many support realtime searching in mongo if any :(.
If this is not a problem to you I would always suggest using a specially
designed search tech like Solr or ElasticSearch etc etc.

Post by Julius Somoye
Hi,
I need some advice regarding faceted search in MongoDB. I currently
have around 100 milllion products in my collection. As you would
expect faceted search is very important for the front end search
implementation e.g.http://www.shopwindow.com/productlist.php?rb=4-6
I know MongoDB's map/reduce can offer aggregation/grouping for simple
facets. Having read a few articles online I have the sense that Mongo
is not designed to efficiently handle faceted search. Using map/reduce
for this carries a heavy performance hit from what I have come
across.
I am using the PHP driver. Does anyone know the best solution for
handling faceted search in MongoDB? Will it be better to use a search
engine for the search and MongoDB for CRUD?
Thanks
--
You received this message because you are subscribed to the Google Groups
"mongodb-user" group.
To unsubscribe from this group, send email to
For more options, visit this group at
http://groups.google.com/group/mongodb-user?hl=en.