…; 3) Table with INT: CREATE TABLE cities_join ( id int(10) unsigned NOT NULL auto_increment, state_id tinyint(3) unsigned NOT NULL… 3) Results for INT + join: select SQL_NO_CACHE c.city from cities_join c JOIN states s ON (s.id = c… with ENUM or TINYINT but in fact it is quite expected – This is MyISAM table which is accessed via index, which means…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…vs… | `ssb`.`lineorder` | GEN_CLUST_INDEX | 6001 | 2095 | 3906 | …on…int, D_YearMonth char(7), D_DayNumInWeek tinyint, D_DayNumInMonth tinyint, D_DayNumInYear smallint, D_MonthNumInYear tinyint, D_WeekNumInYear tinyint…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…and couple of extra indexes. CREATE TABLE IF NOT EXISTS `$tableName` ( `id` int(10) unsigned …`city` varchar(64) NOT NULL default ”, `state_id` tinyint(3) unsigned NOT NULL default ’0′, `zip`…: This benchmark is synthetic micro benchmarks focusing on particular simple data access patterns. Results …
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…TINYINT(4) DEFAULT NULL, `CarrierDelay` INT(11) DEFAULT NULL, `WeatherDelay` INT(11) DEFAULT NULL, `NASDelay` INT(11) DEFAULT NULL, `SecurityDelay` INT(11) DEFAULT NULL, `LateAircraftDelay` INT…really about InfoBright vs MonetDB comparison….indexes like InfoBright, but results are impressive. On …
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… to ones in benchmark InnoDB vs MyISAM vs Falcon (http://www….of extra indexes. CREATE TABLE IF NOT EXISTS `$tableName` ( `id` int(10…varchar(64) NOT NULL default ”, `state_id` tinyint(3) unsigned NOT NULL default ’0′,… is synthetic micro benchmarks focusing on particular simple data access patterns…
