Another new year by Jewish calendar. What do I wish for the following year?
- World peace
- Good health to all
- Multi-core execution for queries
After having evaluated a few columnar databases, and having seen how a single query gets 24 cores busy, I can’t look at MySQL the same way again. The fact that a single query consumes a single core only doesn’t seem right in the year 2014. Shard-query is a cool application-level attempt to solve the above; I would like to see stuff like this implemented inside the server (or inside the storage engine where possible).
None of my wishes in previous years [2010], [2011], [2012], [2013] came true (and mostly gone worse). I’m still willing to settle for two out of three.
Vadim,
I evaluated InfoBright, InfiniDB and Vertica (the latter I only evaluated briefly and I can’t claim deep understanding — and anyway ownership was taken by newly created BI team and declared as winner, rightfully).
Yes, I have some deep insights on Infobright and some not-so-deep insights on InfiniDB.
Some of these insights are not so good (we didn’t adopt any of the two) which is the reason why I’m still postponing publishing my results.