…alignright” width=”210″] MySQL 5.6 vs MySQL 5.5 & the Star Schema…time=0: mysql> select straight_join sum(lo_extendedprice*lo_discount) as revenue from dim_date…varchar(25), C_Address varchar(25), C_City varchar(10), C_Nation varchar(15), C_Region varchar(12), C_Phone varchar(15), C_MktSegment varchar…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…, `name` varchar(64) NOT NULL default ”, `email` varchar(64) NOT NULL default ”, `password` varchar(64) NOT NULL default ”, `dob` date default NULL, `address` varchar(128) NOT NULL default ”, `city` varchar(64… better than MyISAM by 2-26 times and than Falcon by 1.64 – 3.85 times. READ_PK_RANGE_INDEX Query: SELECT…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
… reality only two queries (from 22) have significantly better execution time (about them in next posts), but I want to write…) as revenue FROM lineitem WHERE l_shipdate >= date ’1995-01-01′ AND l_shipdate < date ’1995-01-01′ + interval ’1′ year AND… NULL, `l_commitdate` date NOT NULL, `l_receiptdate` date NOT NULL, `l_shipinstruct` char(25) NOT NULL, `l_comment` varchar(44) NOT NULL…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…date DEFAULT NULL, `UniqueCarrier` char(7) DEFAULT NULL, `AirlineID` int(11) DEFAULT NULL, `Carrier` char(2) DEFAULT NULL, `TailNum` varchar…2006 | 7141922 | | 2007 | 7455458 | | 2008 | 7009728 | +——+———+ And execution time: MonetDB: 6.3s …not really about InfoBright vs MonetDB comparison. …
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… different workloads. This time I tested only READ queries, similar to ones in benchmark InnoDB vs MyISAM vs Falcon (http://www…. `email` varchar(64) NOT NULL default ”, `password` varchar(64) NOT NULL default ”, `dob` date default NULL, `address` varchar(128) NOT NULL default ”, `city` varchar(…
