… times (smaller is better): MyISAM took 88 seconds, MonetDB took 200, and Infobright took 486. Here’s the size of the resulting… on disk (smaller is better): MyISAM is 787MB, MonetDB is 791MB, and Infobright is 317MB. Next I ran three queries: select sum…. Otherwise, Infobright behaved about as I expected it to; it seemed pretty normal to a MySQL guy. Notes on MonetDB MonetDB was a…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
… MonetDB. For InfoBright it took 4.19 sec to execute and 29.9 sec for MonetDB, but it’s almost single case where MonetDB…. It is a bit more trickier, as for InfoBright and MonetDB you need different query: MonetDB: WITH t AS (SELECT carrier, count(*) AS…: MonetDB: 6.3s and InfoBright: 0.31s To group all results there is graph: Conclusions: This experiment was not really about InfoBright vs MonetDB…
Post: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
January 7, 2010 By 48 Comments
… modification, and tried run queries against InfoBright, InfiniDB, LucidDB and MonetDB. I did not get results for MonetDB, will explain later why. Again… MonetDB are also have multi-thread loaders, only InfoBright ICE used single core. InfiniDB: 24 010 sec MonetDB: 42 608 sec (without indexes) InfoBright…
Post: Air traffic queries in MyISAM and Tokutek (TokuDB)
November 5, 2009 By 26 Comments
… is next post in series Analyzing air traffic performance with InfoBright and MonetDB Air traffic queries in LucidDB Air traffic queries in… smart in picking best one. The really nice thing about MonetDB, InfoBright, InfiniDB is that they do not need indexes, so you….mysqlperformanceblog.com/2009/10/02/analyzing-air-traffic-performance-with-infobright-and-monetdb/, and queries I posted on sheet “Queries” in my…
Post: Air traffic queries in InfiniDB: early alpha
November 2, 2009 By 19 Comments
… posts on this topic: Analyzing air traffic performance with InfoBright and MonetDB Air traffic queries in LucidDB I could not run all… time for queries it can handle, quite often better than InfoBright. Inability to handle derived tables is significant drawback for me…
Post: Air traffic queries in LucidDB
October 26, 2009 By 20 Comments
… InfoBright it is 1.6GB, and for MonetDB – 65GB. Obviously LucidDB uses some compression, but it is not so aggressive as in InfoBright… otp.”ontime”; 1 row selected (55.165 seconds) Both InfoBright and MonetDB returned result immediately. It seems LucidDB has to scan whole… 2008 GROUP BY “DestCityName” ORDER BY 2 DESC; Years, LucidDB, InfoBright, MonetDB 1y, 6.76s, 1.74s, 0.55s 2y, 28.82s…
Comment: Analyzing air traffic performance with InfoBright and MonetDB
February 2, 2010 By 50 Comments
… real-time (10-15 sec) queries on 1B+ row tables. InfoBright, MonetDB, InfiniDB are in my short lists. Having read your article… optimization inside both MonetDB and Infobright. For example, this query takes 7.9 sec for MonetDB and 12 sec for Infobright. -Q1: Count flights…, can you forward my e-mail address and question to MonetDB and Infobright guys? This is query: SELECT T.C FROM T…
Comment: Analyzing air traffic performance with InfoBright and MonetDB
October 3, 2009 By 50 Comments
… do not have indexes like InfoBright.” MonetDB does have indexes, but in contrast to most other engines, MonetDB creates and destroys them itself… tune is better” approach that MonetDB takes. I’m still trying to understand here why “MonetDB does not like to scan many… does a plain full scan, it for sure loses from Infobright which really benefits from their excellent compressed storage in that…
Comment: Air traffic queries in MyISAM and Tokutek (TokuDB)
November 6, 2009 By 26 Comments
… seems that only Infobright and MonetDB have good speeds – and I suspect with larger RAM (like 16GB or more) MonetDB would do even… a real server (8 cores/16GB+ RAM etc) along with Infobright and MonetDB to see how they can use better hardware?
Post: New OLAP Wikistat benchmark: Introduction and call for feedbacks
January 28, 2010 By 16 Comments
…-schema-bechmark-infobright-infinidb-and-luciddb/ http://www.mysqlperformanceblog.com/2009/10/02/analyzing-air-traffic-performance-with-infobright-and-monetdb/ http://www… available engines: MySQL MyISAM / InnoDB (to have reference results) InfoBright InfiniDB MonetDB LucidDB Greenplum and I will report my results ( so stay…
