Use random sampling of data to determine field cardinalities

[genixpro]

Hello,

My name is Brad. I have used Dex quite a bit, but I found it frustrating that I would have to manually hand-tune the indexes after wards. Dex just doesn't go far enough.

The one particular feature that is really missing from Dex is the ability to automatically sort its recommended indexes by the cardinality of its fields.

After becoming very frustrated having to hand tune the results every time, I eventually created my own tool.

https://bitbucket.org/sensibill/mongo-dynamic-indexer/overview

I would really suggest you guys at Mongolab come check it out. I have developed an algorithm that can automatically sort indexes by their cardinality, and a whole lot more. I hope we can collaborate. Either way, I recommend field cardinality sorting as a feature for Dex.