GoFuckYourself.com - Adult Webmaster Forum - View Single Post - is it normal for mysql to take 14+ seconds to do 10k inserts?

Myst · 02-18-2007, 05:47 AM

the thing is i will be doing many many single inserts, so i set it to do one at a time on purpose

the problem was the table structure

INNODB is 7-8x faster than InnoDB (at least on windows anyway)

02-18-2007, 05:47 AM
Myst Confirmed User Join Date: Feb 2004 Location: Alberta, Canada Posts: 4,708	the thing is i will be doing many many single inserts, so i set it to do one at a time on purpose the problem was the table structure INNODB is 7-8x faster than InnoDB (at least on windows anyway) __________________ ICQ: 298-523-037