… performance when you use 3 different approaches: ENUM, VARCHAR and tinyint (+joined table) columns. In practice you can also often use…; 3) Table with INT: CREATE TABLE cities_join ( id int(10) unsigned NOT NULL auto_increment, state_id tinyint(3) unsigned NOT NULL… look counterintuitive because table is significantly smaller with ENUM or TINYINT but in fact it is quite expected – This is MyISAM…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…id=”attachment_13599″ align=”alignright” width=”210″] MySQL 5.6 vs MySQL 5.5 & the Star Schema Benchmark[/caption] So …smallint, D_YearMonthNum int, D_YearMonth char(7), D_DayNumInWeek tinyint, D_DayNumInMonth tinyint, D_DayNumInYear smallint, D_MonthNumInYear tinyint, D_WeekNumInYear tinyint, D_…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… of extra indexes. CREATE TABLE IF NOT EXISTS `$tableName` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(64) NOT… NULL default ”, `city` varchar(64) NOT NULL default ”, `state_id` tinyint(3) unsigned NOT NULL default ’0′, `zip` varchar(8) NOT…
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… Conclusions: This experiment was not really about InfoBright vs MonetDB comparison. My goal was to check …
Comment: How adding another table to JOIN can improve performance ?
August 3, 2008 By 12 Comments
…yy smallint # YEAR() qq tinyint # QUARTER() yyqq int # mm tinyint # dd tinyint wknum1 tinyint # WEEK() yywknum1 int # YEARWEEK() wknum2 tinyint # some things define the first…comparing Summer Saturday revenue on day hotter than 85F vs days cooler than that. Outdoor restaurants, boat rentals, downtown…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
…queries, similar to ones in benchmark InnoDB vs MyISAM vs Falcon (http://www.mysqlperformanceblog.com/… CREATE TABLE IF NOT EXISTS `$tableName` ( `id` int(10) unsigned NOT NULL auto_increment, `name` …`city` varchar(64) NOT NULL default ”, `state_id` tinyint(3) unsigned NOT NULL default ’0′, `zip` …
