… a bit more trickier, as for InfoBright and MonetDB you need different query: MonetDB: WITH t AS (SELECT carrier, count(*) AS c…, 219 ] And with execution time 27.9s MonetDB and 8.59s InfoBright. It seems MonetDB does not like scanning wide range of… if you want to compare or get info about air performance.
Post: Quick comparison of MyISAM, Infobright, and MonetDB
September 29, 2009 By 30 Comments
… (the same one Peter wrote about recently). The client’s performance is suffering in part because of the number of columns… how fast MyISAM vs. MonetDB would interpret really large INSERT statements, the kind produced by mysqldump. But MonetDB choked and told me…; it seemed pretty normal to a MySQL guy. Notes on MonetDB MonetDB was a bit different. I had to be a bit…
Post: Air traffic queries in LucidDB
October 26, 2009 By 20 Comments
After my first post Analyzing air traffic performance with InfoBright and MonetDB where I was not able to finish task with LucidDB….”ontime”; 1 row selected (55.165 seconds) Both InfoBright and MonetDB returned result immediately. It seems LucidDB has to scan whole…”=t2.”Year”); LucidDB: 106.374 seconds InfoBright: 8.59 sec MonetDB: 27.9 sec – Q8: SELECT “DestCityName”, COUNT( DISTINCT “OriginCityName”) FROM…
Post: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
January 7, 2010 By 46 Comments
…://www.mysqlperformanceblog.com/2009/10/02/analyzing-air-traffic-performance-with-infobright-and-monetdb/, http://www.mysqlperformanceblog.com/2009/10/26/air… run queries against InfoBright, InfiniDB, LucidDB and MonetDB. I did not get results for MonetDB, will explain later why. Again primary goal…
Post: Air traffic queries in MyISAM and Tokutek (TokuDB)
November 5, 2009 By 26 Comments
This is next post in series Analyzing air traffic performance with InfoBright and MonetDB Air traffic queries in LucidDB Air traffic queries…://www.mysqlperformanceblog.com/2009/10/02/analyzing-air-traffic-performance-with-infobright-and-monetdb/, and queries I posted on sheet “Queries” in…
Comment: TPC-H Run on MySQL 5.1 and 6.0
July 14, 2008 By 16 Comments
… problem (Kickfire), others exploit different ways of software layering (Vertica, MonetDB). From an software architecture point of view understanding the pro… the insiders, because the performance of MySQL does not stand out against the fullscale (OLTP +DW) version of MonetDB. Any reference to… the good work on database kernels Martin ps http://monetdb.cwi.nl/projects/monetdb//SQL/Benchmark/TPCH/ for an indication. Numbers are…
Comment: Analyzing air traffic performance with InfoBright and MonetDB
October 31, 2009 By 50 Comments
… of VectorWise/Ingres does) MonetDB does, however, use the minimal data types required to store information. – MonetDB automatically builds a dictionary system…) and TRACE (for detailed performance trace) We would appreciate those for inspection. – same for Q9. Note that MonetDB does not create any…
Comment: Analyzing air traffic performance with InfoBright and MonetDB
February 2, 2010 By 50 Comments
… tables. InfoBright, MonetDB, InfiniDB are in my short lists. Having read your article first time I was impressed by performance numbers of columnar databases, but now … I think that there are a lot of room for query optimization inside both MonetDB and Infobright. For example, this query takes 7.9 sec for MonetDB and 12 sec for…
Comment: Analyzing air traffic performance with InfoBright and MonetDB
October 5, 2009 By 50 Comments
….g. http://www.monetdb.nl/projects/monetdb/SQL/Benchmark/TPCH/index.html. And I know some companies optimizes performance of database especially for TPC-H load ( I do not point here to InfoBright nor MonetDB, I do…
Comment: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
January 10, 2010 By 46 Comments
… virtual memory (swap space). Stride-by-stride our already great performance improves (see your previous benchmark), only partly hindered by the… our Linux system administrators consider the minimum. Not only for MonetDB, but to support all kind of applications, e.g. Matlab… a consistent database. A side-effect of constraint checking in MonetDB is the automatic construction of join-indices, which would speed…
