Hi,
I have the following table :
CREATE TABLE `raw_outgoing_sms` (
`id` bigint(20) NOT NULL auto_increment,
`id_gsm_operator` bigint(20) NOT NULL default '0',
`id_shortcode` bigint(20) NOT NULL default '0',
`msisdn` varchar(20) NOT NULL default '',
`sender` varchar(20) NOT NULL default '',
`ts` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`text` text,
`udh` text,
`data` text NOT NULL,
`dlr_status` varchar(20) default NULL,
`dlr_url` text,
PRIMARY KEY (`id`),
KEY `idx_outgoing_gsm_op` (`id_gsm_operator`),
KEY `idx_outgoing_shortcode` (`id_shortcode`)
) ENGINE=InnoDB
When i insert data into it it takes around 11 seconds. Why ?
Thanks,
Catalin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
