Tag Archives: indexing

532x Multikey Index Insertion Performance Increase...

Posted on by Tim Callaghan

In my three previous MongoDB blogs I wrote about our implementation of Fractal Tree(R) indexes on MongoDB, showing a 10x insertion performance increase, a 268x query performance increase, and a comparison of covered indexes and clustered indexes….

2 Comments

My Talk Next Week at HighLoad++

Posted on by Gerry Narvaja

Next week I’ll be visiting Moscow to talk at Highload++…. The conference will take place during Monday 22nd and Tuesday 23rd at the Radisson hotel. I will be giving my personal version of an indexing talk that my colleagues

1 Comment

Looking for MongoDB users to test Fractal Tree...

Posted on by Tim Callaghan

In my three previous blogs I wrote about our implementation of Fractal Tree Indexes on MongoDB, showing a 10x insertion performance increase, a 268x query performance increase, and a comparison of covered indexes and clustered indexes…. The

1 Comment

MongoDB Index Shootout: Covered Indexes vs....

Posted on by Tim Callaghan

In my two previous blogs I wrote about our implementation of Fractal Tree Indexes on MongoDB, showing a 10x insertion performance increase and a 268x query performance increase. MongoDB’s covered indexes… can provide some performance benefits over a regular

6 Comments

Webinar: Understanding Indexing

Posted on by Zardosht Kasheff

Three rules on making indexes around queries to provide good performance
Application performance often depends on how fast a query can respond and query performance almost always depends on good indexing. So one of the quickest and least expensive ways…

1 Comment

Fractal Tree Indexing and Filesystems –...

Posted on by John Esmet

Modern file systems are well equipped to deal with large writes. One area that remains challenging however is to efficiently write out “microdata”, such as metadata and small portions of large files, while showing good I/O utilization when the data…

Leave a comment

FictionPress Selects TokuDB for Consistent...

Posted on by admin

FictionPress
Issues addressed:

Support complex and efficient indexes at 100+ million rows.
Predicable and consistent performance regardless of data size growth.
Fast recovery.

Ensuring Predictable Performance at Scale
The Company:  FictionPress operates both FictionPress.com and FanFiction.net… and is home to

2 Comments

Understanding Indexing – NY Effective MySQL...

Posted on by Zardosht Kasheff

At next week’s NY Effective MySQL Meetup…, I will give a talk: “Understanding Indexing: Three rules on making indexes around queries to provide good performance.” The meetup is 7 pm Tuesday, October 11th, and will be held at Hive

Leave a comment

Write Optimization: Myths, Comparison,...

Posted on by leif

In my last post…, we talked about the read/write tradeoff of indexing data structures, and some ways that people augment B-trees in order to get better write performance. We also talked about the significant drawbacks of each method, and

13 Comments

Are You Forcing MySQL to Do Twice as Many JOINs as...

Posted on by Percona

.
Baron Schwartz
This guest post is from our friends at Percona. They’re hosting Percona Live London… from October 24-25, 2011. Percona Live is a two day summit with 100% technical sessions led by some of the most established

6 Comments