-- Test summary: Dell Precision 380 Win XP 2002 Service Pack 2 CPU: Intel Pentium 4 CPU 3.60 GHz Total Memory: 2.00 GB Test table with 150 columns CREATE TABLE `mysql`.`inserttable` ( `1_TIMES` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `2_INT` int(11) NOT NULL, `3_VARCHAR` varchar(32) NOT NULL, `4_VARCHAR` varchar(32) NOT NULL, `5_TIN` tinyint(4) DEFAULT NULL, `6_SMAL` smallint(6) DEFAULT NULL, `7_INT` int(11) DEFAULT NULL, `8_INT` int(11) DEFAULT NULL, `9_INT` int(11) DEFAULT NULL, `10_VARCHA` varchar(4) DEFAULT NULL, `11_VARCHA` varchar(6) DEFAULT NULL, `12_INT` int(11) DEFAULT NULL, `13_VARCHAR` varchar(10) DEFAULT NULL, `14_INT` int(11) DEFAULT NULL, `15_VARCHAR` varchar(16) DEFAULT NULL, `16_VARCHAR` varchar(18) DEFAULT NULL, `17_INT` int(11) DEFAULT NULL, `18_VARCHAR` varchar(32) DEFAULT NULL, `19_INT` int(11) DEFAULT NULL, `20_BINAR` binary(3) DEFAULT NULL, `21_INT` int(11) DEFAULT NULL, `22_BINAR` binary(5) DEFAULT NULL, `23_TIMES` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `24_TIN` tinyint(4) DEFAULT NULL, `25_SMAL` smallint(6) DEFAULT NULL, `26_INT` int(11) DEFAULT NULL, `27_INT` int(11) DEFAULT NULL, `28_INT` int(11) DEFAULT NULL, `29_VARCHA` varchar(4) DEFAULT NULL, `30_VARCHA` varchar(6) DEFAULT NULL, `31_INT` int(11) DEFAULT NULL, `32_VARCHAR` varchar(10) DEFAULT NULL, `33_INT` int(11) DEFAULT NULL, `34_VARCHAR` varchar(16) DEFAULT NULL, `35_VARCHAR` varchar(18) DEFAULT NULL, `36_INT` int(11) DEFAULT NULL, `37_VARCHAR` varchar(32) DEFAULT NULL, `38_INT` int(11) DEFAULT NULL, `39_BINAR` binary(3) DEFAULT NULL, `40_INT` int(11) DEFAULT NULL, `41_BINAR` binary(5) DEFAULT NULL, `42_TIMES` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `43_TIN` tinyint(4) DEFAULT NULL, `44_SMAL` smallint(6) DEFAULT NULL, `45_INT` int(11) DEFAULT NULL, `46_INT` int(11) DEFAULT NULL, `47_INT` int(11) DEFAULT NULL, `48_VARCHA` varchar(4) DEFAULT NULL, `49_VARCHA` varchar(6) DEFAULT NULL, `50_INT` int(11) DEFAULT NULL, `51_VARCHAR` varchar(10) DEFAULT NULL, `52_INT` int(11) DEFAULT NULL, `53_VARCHAR` varchar(16) DEFAULT NULL, `54_VARCHAR` varchar(18) DEFAULT NULL, `55_INT` int(11) DEFAULT NULL, `56_VARCHAR` varchar(32) DEFAULT NULL, `57_INT` int(11) DEFAULT NULL, `58_BINAR` binary(3) DEFAULT NULL, `59_INT` int(11) DEFAULT NULL, `60_BINAR` binary(5) DEFAULT NULL, `61_TIMES` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `62_TIN` tinyint(4) DEFAULT NULL, `63_SMAL` smallint(6) DEFAULT NULL, `64_INT` int(11) DEFAULT NULL, `65_INT` int(11) DEFAULT NULL, `66_INT` int(11) DEFAULT NULL, `67_VARCHA` varchar(4) DEFAULT NULL, `68_VARCHA` varchar(6) DEFAULT NULL, `69_INT` int(11) DEFAULT NULL, `70_VARCHAR` varchar(10) DEFAULT NULL, `71_INT` int(11) DEFAULT NULL, `72_VARCHAR` varchar(16) DEFAULT NULL, `73_VARCHAR` varchar(18) DEFAULT NULL, `74_INT` int(11) DEFAULT NULL, `75_VARCHAR` varchar(32) DEFAULT NULL, `76_INT` int(11) DEFAULT NULL, `77_BINAR` binary(3) DEFAULT NULL, `78_INT` int(11) DEFAULT NULL, `79_BINAR` binary(5) DEFAULT NULL, `80_TIMES` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `81_TIN` tinyint(4) DEFAULT NULL, `82_SMAL` smallint(6) DEFAULT NULL, `83_INT` int(11) DEFAULT NULL, `84_INT` int(11) DEFAULT NULL, `85_INT` int(11) DEFAULT NULL, `86_VARCHA` varchar(4) DEFAULT NULL, `87_VARCHA` varchar(6) DEFAULT NULL, `88_INT` int(11) DEFAULT NULL, `89_VARCHAR` varchar(10) DEFAULT NULL, `90_INT` int(11) DEFAULT NULL, `91_VARCHAR` varchar(16) DEFAULT NULL, `92_VARCHAR` varchar(18) DEFAULT NULL, `93_INT` int(11) DEFAULT NULL, `94_VARCHAR` varchar(32) DEFAULT NULL, `95_INT` int(11) DEFAULT NULL, `96_BINAR` binary(3) DEFAULT NULL, `97_INT` int(11) DEFAULT NULL, `98_BINAR` binary(5) DEFAULT NULL, `99_TIMES` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `100_TIN` tinyint(4) DEFAULT NULL, `101_SMAL` smallint(6) DEFAULT NULL, `102_INT` int(11) DEFAULT NULL, `103_INT` int(11) DEFAULT NULL, `104_INT` int(11) DEFAULT NULL, `105_VARCHA` varchar(4) DEFAULT NULL, `106_VARCHA` varchar(6) DEFAULT NULL, `107_INT` int(11) DEFAULT NULL, `108_VARCHAR` varchar(10) DEFAULT NULL, `109_INT` int(11) DEFAULT NULL, `110_VARCHAR` varchar(16) DEFAULT NULL, `111_VARCHAR` varchar(18) DEFAULT NULL, `112_INT` int(11) DEFAULT NULL, `113_VARCHAR` varchar(32) DEFAULT NULL, `114_INT` int(11) DEFAULT NULL, `115_BINAR` binary(3) DEFAULT NULL, `116_INT` int(11) DEFAULT NULL, `117_BINAR` binary(5) DEFAULT NULL, `118_TIMES` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `119_TIN` tinyint(4) DEFAULT NULL, `120_SMAL` smallint(6) DEFAULT NULL, `121_INT` int(11) DEFAULT NULL, `122_INT` int(11) DEFAULT NULL, `123_INT` int(11) DEFAULT NULL, `124_VARCHA` varchar(4) DEFAULT NULL, `125_VARCHA` varchar(6) DEFAULT NULL, `126_INT` int(11) DEFAULT NULL, `127_VARCHAR` varchar(10) DEFAULT NULL, `128_INT` int(11) DEFAULT NULL, `129_VARCHAR` varchar(16) DEFAULT NULL, `130_VARCHAR` varchar(18) DEFAULT NULL, `131_INT` int(11) DEFAULT NULL, `132_VARCHAR` varchar(32) DEFAULT NULL, `133_INT` int(11) DEFAULT NULL, `134_BINAR` binary(3) DEFAULT NULL, `135_INT` int(11) DEFAULT NULL, `136_BINAR` binary(5) DEFAULT NULL, `137_TIMES` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `138_TIN` tinyint(4) DEFAULT NULL, `139_SMAL` smallint(6) DEFAULT NULL, `140_INT` int(11) DEFAULT NULL, `141_INT` int(11) DEFAULT NULL, `142_INT` int(11) DEFAULT NULL, `143_VARCHA` varchar(4) DEFAULT NULL, `144_VARCHA` varchar(6) DEFAULT NULL, `145_INT` int(11) DEFAULT NULL, `146_VARCHAR` varchar(10) DEFAULT NULL, `147_INT` int(11) DEFAULT NULL, `148_VARCHAR` varchar(16) DEFAULT NULL, `149_VARCHAR` varchar(18) DEFAULT NULL, `150_INT` int(11) DEFAULT NULL, PRIMARY KEY (`1_TIMES`,`2_INT`), KEY `InsertTableIndex1` (`3_VARCHAR`), KEY `InsertTableIndex2` (`4_VARCHAR`) ) ENGINE=Falcon DEFAULT CHARSET=utf8; Example of inserted row: '2007-02-06 09:19:47', 4527532, '3584147483650', '3584147083647', 127, 32767, -2147483648, 47483648, 2147430480, 'vc_4', 'vchar6', -10000, 'varchar_10', 100000000, 'varchar16merkkia', 'varchar_18_-------', 440000, 'varchar32_merkkia_--------------', -100000000, 'jot', -2147483648, 'jotai', '2007-02-06 09:19:47', 127, 32767, -2147483648, 47483648, 2147430480, 'vc_4', 'vchar6', -10000, 'varchar_10', 100000000, 'varchar16merkkia', 'varchar_18_-------', 440000, 'varchar32_merkkia_--------------', -100000000, 'jot', -2147483648, 'jotai', '2007-02-06 09:19:47', 127, 32767, -2147483648, 47483648, 2147430480, 'vc_4', 'vchar6', -10000, 'varchar_10', 100000000, 'varchar16merkkia', 'varchar_18_-------', 440000, 'varchar32_merkkia_--------------', -100000000, 'jot', -2147483648, 'jotai', '2007-02-06 09:19:47', 127, 32767, -2147483648, 47483648, 2147430480, 'vc_4', 'vchar6', -10000, 'varchar_10', 100000000, 'varchar16merkkia', 'varchar_18_-------', 440000, 'varchar32_merkkia_--------------', -100000000, 'jot', -2147483648, 'jotai', '2007-02-06 09:19:47', 127, 32767, -2147483648, 47483648, 2147430480, 'vc_4', 'vchar6', -10000, 'varchar_10', 100000000, 'varchar16merkkia', 'varchar_18_-------', 440000, 'varchar32_merkkia_--------------', -100000000, 'jot', -2147483648, 'jotai', '2007-02-06 09:19:47', 127, 32767, -2147483648, 47483648, 2147430480, 'vc_4', 'vchar6', -10000, 'varchar_10', 100000000, 'varchar16merkkia', 'varchar_18_-------', 440000, 'varchar32_merkkia_--------------', -100000000, 'jot', -2147483648, 'jotai', '2007-02-06 09:19:47', 127, 32767, -2147483648, 47483648, 2147430480, 'vc_4', 'vchar6', -10000, 'varchar_10', 100000000, 'varchar16merkkia', 'varchar_18_-------', 440000, 'varchar32_merkkia_--------------', -100000000, 'jot', -2147483648, 'jotai', '2007-02-06 09:19:47', 127, 32767, -2147483648, 47483648, 2147430480, 'vc_4', 'vchar6', -10000, 'varchar_10', 100000000, 'varchar16merkkia', 'varchar_18_-------', 440000 Results of full speed test (a small program executing INSERTs via ODBC as fast as possible, row commit interval: 2000 rows) : MyISAM with configuration parameters: max_connections=341 query_cache_size=9M table_cache=700 tmp_table_size=16M thread_cache_size=17 myisam_max_sort_file_size=100G myisam_max_extra_sort_file_size=100G myisam_sort_buffer_size=8M key_buffer_size=13M read_buffer_size=64K read_rnd_buffer_size=256K sort_buffer_size=208K skip-innodb => results: 150 columns in insert table: approx 1600 rows / s 400 columns: approx 890 rows/s Falcon with configuration parameters: max_connections=341 query_cache_size=9M table_cache=700 tmp_table_size=16M thread_cache_size=17 myisam_max_sort_file_size=100G myisam_max_extra_sort_file_size=100G myisam_sort_buffer_size=8M key_buffer_size=13M read_buffer_size=64K read_rnd_buffer_size=256K sort_buffer_size=208K skip-innodb falcon_min_record_memory=100M falcon_max_record_memory=512M => 150 colums in insert table: approx 1900 rows /s 400 columns: approx 930 rows/s