MongoDB 2.6 Improves Open-Source Database Performance

Among the new features in MongoDB 2.6 is one called Index Intersection. Stirman said index intersection enables the query planner to use more than one index to resolve a query.

“With index intersection, developers can address more queries with simple indexes and with less upfront index design,” Stirman said.

Stirman said that as an example, in a sales reporting application, a product manager might want to identify all customers who have ordered more than a given quantity of a specific part number. Using index intersection, the existing indexes for part number and quantity can be combined (intersected) to optimize the query, rather than requiring a separate compound index. This also results in reduced overhead to the working set size, and more efficient updates.

Read the full story at DatabaseJournal:
MongoDB 2.6 Improves Open-Source Database Performance

Sean Michael Kerner is a senior editor at InternetNews.com. Follow him on Twitter @TechJournalist.