MYSQL插入速度太慢,求支招,怎么能快些
INSERT INTO `goods` (`num_iid`, `title`, `pic_url`, `detail_url`, `price`, `coupon_price`, `num`, `create_user_id`, `create_time`, `description`, `category_id`, `end_time`, `volume`, `promote_id`, `freight_payer`, `nick`, `begin_time`, `pindao_id`, `commission_rate`, `sort`, `flag`) VALUES
(41698968410, '艾路丝婷2014新款冬裝韩版长袖T恤女加绒加厚蕾丝打底衫体恤1179', 'http://gi2.mlist.alicdn.com/bao/uploaded/i2/606753541/TB2fVt2aVXXXXX.XpXXXXXXXXXX_!!606753541.jpg', 'http://item.taobao.com/item.htm?id=41698968410', '108.00', '108.00', 22802, 0, 1410399361, '', 1, 1424102400, 0, 35, 'buyer', '777旗舰店', 1415757600, 0, NULL, 0, 0),
(40369044661, '裂帛2014秋冬新款彩色波普几何拼接堆领长袖T 5114103T', 'http://gi1.mlist.alicdn.com/bao/uploaded/i1/228784630/TB20bOgaFXXXXbnXXXXXXXXXXXX_!!228784630.jpg', 'http://item.taobao.com/item.htm?id=40369044661', '149.80', '149.80', 22802, 0, 1410399361, '', 1, 1424102400, 0, 35, 'buyer', '777旗舰店', 1415757600, 0, NULL, 0, 0),
(40573257153, '韩版印花长袖白色T恤女款 2014秋装新款 时尚修身打底衫短款上衣', 'http://gi4.mlist.alicdn.com/bao/uploaded/i4/913099165/TB2G0W7aXXXXXasXXXXXXXXXXXX_!!913099165.jpg', 'http://item.taobao.com/item.htm?id=40573257153', '128.00', '128.00', 22802, 0, 1410399361, '', 1, 1424102400, 0, 35, 'buyer', '777旗舰店', 1415757600, 0, NULL, 0, 0),
(40848339907, '郴牌2014秋装中年圆领长袖t恤女大码新款长袖加绒加厚打底衫女冬', 'http://gi2.mlist.alicdn.com/bao/uploaded/i2/1643743239/TB2kYeNaVXXXXbHXXXXXXXXXXXX_!!1643743239.jpg', 'http://item.taobao.com/item.htm?id=40848339907', '129.00', '129.00', 22802, 0, 1410399361, '', 1, 1424102400, 0, 35, 'buyer', '777旗舰店', 1415757600, 0, NULL, 0, 0),
(39934533031, '预售呛口小辣椒秋装新款 打底印花 长袖修身针织T恤 女 61140192', 'http://gi2.mlist.alicdn.com/bao/uploaded/i2/823295866/TB2DkNrbXXXXXa0XXXXXXXXXXXX_!!823295866.jpg', 'http://item.taobao.com/item.htm?id=39934533031', '119.00', '119.00', 22802, 0, 1410399361, '', 1, 1424102400, 0, 35, 'buyer', '777旗舰店', 1415757600, 0, NULL, 0, 0),
(41859112625, '2014新款 烫钻皮绒冬打底衫 女长袖加绒加厚秋冬潮 短款修身小衫', 'http://gi1.mlist.alicdn.com/bao/uploaded/i1/1677255724/TB2Kr1HaVXXXXa_XpXXXXXXXXXX_!!1677255724.jpg', 'http://item.taobao.com/item.htm?id=41859112625', '113.00', '113.00', 22802, 0, 1410399361, '', 1, 1424102400, 0, 35, 'buyer', '777旗舰店', 1415757600, 0, NULL, 0, 0)
......................................................................
用这样的方式直接在phpmysql 里自动生成ID执行操作,但是速度很慢,1000条就要2分钟,超过1000条还执行不了。有什么办法让速度快些吗?或者什么方法让每条数据自动生成连续的ID,然后再导入进数据库也行。