php_dave Posted February 28, 2008 Share Posted February 28, 2008 Hello All, Sorry if this has been posted before - I couldnt find anything. I have a table: # Table "service_order_command" DDL CREATE TABLE `service_order_command` ( `SOC_ID` int(11) NOT NULL, `SOC_COMMAND_ID` int(11) default NULL, `SOC_COM_REF_ID` int(11) default NULL, `SOC_CLI` int(11) default NULL, `SOC_ACCOUNT_NO` varchar(11) default NULL, `SOC_STATUS` varchar(255) default NULL, `SOC_LAST_UPDATE_TIME` date default NULL, `SOC_INSERT_TIME` date default NULL, `SOC_GO_LIVE_DATE` date default NULL, `SOC_ERROR_CODE` int(11) default NULL, `SOC_RESELLER_REFERENCE` varchar(255) default NULL, PRIMARY KEY (`SOC_ID`), UNIQUE KEY `SOC_ID` (`SOC_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 2046976 kB; InnoDB free: 2049024 kB; InnoDB fre' This table holds around 150k rows and grows by around 2 - 3k a day - Unfortuantley due to some very bad db design (not me!) I have to run an insert update on key every 2hrs. The issue is the performance is extremley poor - its taking around 3hrs !! and the server that mysql is running on goes to 100%CPU at the time too. Have I made a school boy error or is it expected to be this slow? Thanks Dave Quote Link to comment https://forums.phpfreaks.com/topic/93545-insert-on-key-update-performance/ Share on other sites More sharing options...
fenway Posted February 28, 2008 Share Posted February 28, 2008 What's your sql statment? Quote Link to comment https://forums.phpfreaks.com/topic/93545-insert-on-key-update-performance/#findComment-479424 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.