… multi-thread loaders, only InfoBright ICE used single core. InfiniDB: 24 010 sec MonetDB: 42 608 sec (without indexes) InfoBright: 51 779 sec… http://infinidb.org/infinidb-blog/mysql-parallel-query-processing-of-ssb-queries-via-infinidb-.html SSB benchmark may be not good for InfoBright, the…
Post: Air traffic queries in InfiniDB: early alpha
November 2, 2009 By 19 Comments
… traffic performance with InfoBright and MonetDB Air traffic queries in LucidDB I could not run all queries against InfiniDB and I met…. Review the Calpont InfiniDB Syntax guide for additional information on supported distributed syntax or consider changing the InfiniDB Operating Mode (infinidb_vtable_mode… deal with different glitches. InfiniDB shows really good time for queries it can handle, quite often better than InfoBright. Inability to handle…
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… queries, some of which were provided by Infobright and others which I contributed. InfiniDB does not support as many data types and…
Post: Air traffic queries in MyISAM and Tokutek (TokuDB)
November 5, 2009 By 26 Comments
… Analyzing air traffic performance with InfoBright and MonetDB Air traffic queries in LucidDB Air traffic queries in InfiniDB: early alpha Let me… in picking best one. The really nice thing about MonetDB, InfoBright, InfiniDB is that they do not need indexes, so you may….mysqlperformanceblog.com/2009/10/02/analyzing-air-traffic-performance-with-infobright-and-monetdb/, and queries I posted on sheet “Queries” in…
Post: New OLAP Wikistat benchmark: Introduction and call for feedbacks
January 28, 2010 By 16 Comments
…/star-schema-bechmark-infobright-infinidb-and-luciddb/ http://www.mysqlperformanceblog.com/2009/10/02/analyzing-air-traffic-performance-with-infobright-and-monetdb/ http… against available engines: MySQL MyISAM / InnoDB (to have reference results) InfoBright InfiniDB MonetDB LucidDB Greenplum and I will report my results ( so…
Comment: Analyzing air traffic performance with InfoBright and MonetDB
February 2, 2010 By 50 Comments
…-time (10-15 sec) queries on 1B+ row tables. InfoBright, MonetDB, InfiniDB are in my short lists. Having read your article first… 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 8, 2010 By 46 Comments
… Infobright, I must first state that I am an Infobright employee. In fact, I am the Director of Technical Sales Consulting. Yes, Infobright offers both a community and commercial edition of the same code line. And it is also true that InfiniDB is… LucidDB known as DynamoDB. The same goes for MonetDB, too. Infobright‘s current differentiation between the fully-functional commercial product and…
Comment: Testing MySQL column stores
August 16, 2010 By 15 Comments
Hi Michael, The Infobright storage engine (ICE) is a column store. MyISAM and InnoDB … engines, even those that support compression. Keep in mind that Infobright is designed for analytical type queries. Like any column store… would need indexes to run the queries. Neither ICE nor InfiniDB need to create indexes, in fact, neither database even supports…
Comment: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
January 12, 2010 By 46 Comments
… product and a large number fixed in any given release. Infobright does a good job of reporting to changes in the… be clear, I would not go out and buy Infobright, Kickfire, InfiniDB, Oracle or any other database product unless I was at…
Comment: High Rate insertion with MySQL and Innodb
January 8, 2011 By 16 Comments
… very good any time soon. Solutions range from using Infobright or InfiniDB to going to other databases and even use Hadoop, Hive…
