… a bit more trickier, as for InfoBright and MonetDB you need different query: MonetDB: WITH t AS (SELECT carrier, count(*) AS c…: 0.5s for MonetDB and 2.92s for InfoBright. Warnings: do not try EXPLAIN this query in InfoBright. MySQL is really stupid… is graph: Conclusions: This experiment was not really about InfoBright vs MonetDB comparison. My goal was to check how available OpenSource software…
Post: Quick comparison of MyISAM, Infobright, and MonetDB
September 29, 2009 By 30 Comments
… see how fast MyISAM vs. MonetDB would interpret really large INSERT statements, the kind produced by mysqldump. But MonetDB choked and told me… expected it to; it seemed pretty normal to a MySQL guy. Notes on MonetDB MonetDB was a bit different. I had to be… it instructions in MonetDB Assembly Language (MAL), the underlying language. An abstracted front-end is a great idea; MySQL abstracts the storage…
Post: Air traffic queries in LucidDB
October 26, 2009 By 20 Comments
… I will show number I have for LucidDB vs previous systems. Load time To load data into… LucidDB: 106.374 seconds InfoBright: 8.59 sec MonetDB: 27.9 sec – Q8: SELECT “DestCityName”, COUNT( DISTINCT “…, transform external data (there is even access to MySQL via JDBC driver) just in SQL queries (compare…
Post: New OLAP Wikistat benchmark: Introduction and call for feedbacks
January 28, 2010 By 16 Comments
…. How many times that or another page was accessed yesterday vs today. Understand specific features and characteristic of each engine. Compare… and run queries against available engines: MySQL MyISAM / InnoDB (to have reference results) InfoBright InfiniDB MonetDB LucidDB Greenplum and I will report…
