… and Baron played with InfoBright (see http://www.mysqlperformanceblog.com/2009/09/29/quick-comparison-of-myisam-infobright-and-monetdb/) this week… for MonetDB and 2.92s for InfoBright. Warnings: do not try EXPLAIN this query in InfoBright. MySQL is really stupid here, and… price for that as I understand), while InfoBright ICE edition allows you only LOAD DATA. InfoBright Enterprise allows INSERT / UPDATE but that…
Post: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
January 7, 2010 By 46 Comments
…-thread loaders, only InfoBright ICE used single core. InfiniDB: 24 010 sec MonetDB: 42 608 sec (without indexes) InfoBright: 51 779 sec… sorted order, loading time can decrease significantly. Datasize after load: InfoBright: 112G LucidDB: 120GB (without indexes) InfiniDB: 626GB MonetDB: 650GB (without… not good for InfoBright, the synthetic nature of benchmark does not allow InfoBright to show better results. But I hope InfoBright will be…
Post: Quick comparison of MyISAM, Infobright, and MonetDB
September 29, 2009 By 30 Comments
…-oriented database. I decided it was time to actually give Infobright a try. They have an open-source community edition, which… the next three together. Notes on Infobright A few miscellaneous notes: don’t forget that Infobright is not just a storage engine… a thing. LOAD DATA INFILE in Infobright isn’t what it seems to be. Otherwise, Infobright behaved about as I expected it…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
… MySQL storage engines. This set of benchmarks evaluates how well Infobright community edition (ICE) performs in combination with Shard-Query. Data… in cooperation with Infobright, including on benchmarking. These particular tests were performed independently of Infobright, without their knowledge or approval. Infobright was, however…
Post: Air traffic queries in LucidDB
October 26, 2009 By 20 Comments
… probably was not truncated after several loads of data. For InfoBright it is 1.6GB, and for MonetDB – 65GB. Obviously LucidDB… some compression, but it is not so aggressive as in InfoBright case. As original dataset is 55GB, compression rate for LucidDB…(*) FROM otp.”ontime”; 1 row selected (55.165 seconds) Both InfoBright and MonetDB returned result immediately. It seems LucidDB has to…
Post: Testing MySQL column stores
August 16, 2010 By 15 Comments
…. The first focused on core functionality and compatibility of ICE (Infobright Community Edition) compared with MyISAM on a small data set… real application. Importantly, I didn’t find significant defects in Infobright that would be “show stoppers” for typical OLAP analysis queries… included 29 different queries, some of which were provided by Infobright and others which I contributed. InfiniDB does not support as…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… database to spread processing over up to 20 nodes. The Infobright Community Edition (ICE) images are available in 32 and 64… the images Amazon ID Name Arch Notesami-20b74949 shard-query-infobright-demo-64bit x86_64 ICE 3.5.2pl1. Requires m1… XtraDB. Requires m1.large or larger. ami-f65ea19f shard-query-infobright-demo i686 ICE 3.5.2pl1 32bit. Requires m1.small…
Comment: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
… was used. This is the Infobright Community Edition storage engine. 2> The data compression is automatic. Infobright is a column store which… dictionary of sorts and it uses “rough set” (http://www.infobright.org/forums/viewthread/113/) theory to eliminate data packs to… EC2 VM based on the ICE EC2 VM (http://www.infobright.org/Blog/Entry/ice_3.5.2_p1_on_the…
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… both MonetDB and Infobright. For example, this query takes 7.9 sec for MonetDB and 12 sec for Infobright. -Q1: Count flights… forward my e-mail address and question to MonetDB and Infobright guys? This is query: SELECT T.C FROM T WHERE…
Comment: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
January 12, 2010 By 46 Comments
… consider our Infobright community edition as you put it “borderline unusable community edition” as we have many professionals using Infobright Community Edition… stick with the use of the free community edition of Infobright. I am also employed by Infobright for full disclosure.
