… MySQL 5.0 as well as designing your applications – you should keep into account if you mind trailing spaces stored choosing VARCHAR vs CHAR in addition to fixed length vs dynamic level rows and space spent for…, even if VARCHAR column is used which is pretty counterintuitive. So “a “=”a”=”a ” for all textual column types – CHAR, VARCHAR, TEXT. BLOB…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…` varchar(64) NOT NULL default ”, `email` varchar(64) NOT NULL default ”, `password` varchar(64) NOT NULL default ”, `dob` date default NULL, `address` varchar(128… used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql-5…
Post: UDF -vs- MySQL Stored Function
September 6, 2010 By 8 Comments
…) two varchar columns needed leading nonalpha characters trimmed, so “123 ^&* and some text” would become “and some text“, and (2) same two varchar columns… long it took to process 100k rows: mysql> select ltrim_junk_mysql(author), ltrim_junk_mysql(title) from paintings limit 100000; 100000 rows…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…varchar(10) DEFAULT NULL, `TotalAddGTime` varchar(10) DEFAULT NULL, `LongestAddGTime` varchar(10) DEFAULT NULL, `DivAirportLandings` varchar(10) DEFAULT NULL, `DivReachedDest` varchar(10) DEFAULT NULL, `DivActualElapsedTime` varchar…: mysql -S /tmp/mysql-ib… load text data (…about InfoBright vs MonetDB…
