MYSQL插入速度太慢，求支招，怎么能快些

2014-11-29 08:08:34 549 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

5090D显卡安装LLaMA-Factory避坑指南：PyTorch与CUDA版本兼容性问题解决本文是针对5090D显卡安装LLaMA-Factory时遇到的PyTorch与CUDA版本兼容性问题的详细解决指南。文章深入剖析了因GPU架构代际差异导致的“no kernel image”报错根源，并提供了从环境诊断、安装匹配的PyTorch Nightly版本，到最终集成验证的完整路径，帮助用户确保LLaMA-Factory在5090D上稳定运行。阅读详情

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,然后再导入进数据库也行。

...全文