May 22, 2012

Post: Introducing new type of benchmark

…way more important metric to compare. I want to pretend that we pioneered… part of day/week/month/year though). And what is important… 128. There are results for 16-128 threads (the result is 99% …=id;js.src=”//platform.twitter.com/widgets.js”;fjs.parentNode.insertBefore…=’100′;ff=’4′;pc=’4889F0′;b

Comment: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB

results. I did a comparison a couple of years ago with a very small (2GB) dataset, results can be seen here: http://www.tholis.com… these results are artificial and cannot be used to make general statements like ‘product A is X times faster than product B

Post: Air traffic queries in MyISAM and Tokutek (TokuDB)

Year` (`Year`,`Month`), KEY `Year_2` (`Year`,`DayOfWeek`), KEY `DayOfWeek` (`DayOfWeek`,`Year`,`DepDelay`), KEY `DestCityName` (`DestCityName`,`OriginCityName`,`Year`), KEY `Year_3` (`Year`,`DestCityName`,`OriginCityName`), KEY `Year_4` (`Yearresults are available in summary Spreadsheet I

Post: Distributed Set Processing with Shard-Query

I could due to to EC2 and time limits. I think the results at 20 nodes are very useful to understand the performance: I… new nodes in data center B and distribute the queries over…date.date_id where dim_date.Year IN (2008,2009) group by 1; –…materialized views: http://scholar.google.com/scholar?hl=en&…

Post: MySQL versions shootout

… vanilla MySQL, not Percona Server. The results are there: There is nothing unexpected, …0 vs MySQL 4.1 couple years ago, I have seen biggest performance hit comes from… po.async = true; po.src = ‘https://apis.google.com/js/plusone.js’; var s = document….’;bw=’100′;ff=’4′;pc=’4889F0′;b=’s…