Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Very slow to insert rows to InnoDB
I tried MartijnTonies's method. It works great. Take less than half second to insert 1000 rows. cdlvj's advise should also works. sleipnir214, I was not using extern file, so I did not try your method. Thanks all for your good advises. -
Very slow to insert rows to InnoDB
Insert into tickets values(null,0,'2003-11-1 00:00:00',7,'8.8','2.3') It is just a test. loop 1000 times. -
Very slow to insert rows to InnoDB
I am using 4.017 version of mysql, and created a fully independent test table like CREATE TABLE tickets ( TicketID bigint(20) NOT NULL auto_increment, TicketNumber int(11) NOT NULL default '0', DateTimeID datetime NOT NULL default '0000-00-00 00:00:00', GameID smallint(6) NOT NULL...
