weixin_33698043 2016-04-24 18:21 采纳率: 0%
浏览 433

插入MYSQl太慢

User keys in search parameters, then we make a request to a data provider and redirect user to a loading page. The response from the data provider hits a callback url, in which case we parse the results and store about 200 rows into the db. Meanwhile the loading page uses ajax to query the db every second and when the results are all there we display the results to the user.

The issue is that insert into the mysql db is too slow. We know the response back from the data provider comes back within seconds, but the processing of the script and inserting of rows into the db is very slow. We do use multirow insert.

Any suggestions to improve? FYI, the code is hugely long... that's why not displaying right now.

  • 写回答

2条回答 默认 最新

  • weixin_33696822 2016-04-24 18:31
    关注

    There are multitude of factors affecting your insertions:

    1) slow hardware and bad server speeds. Sol : Contact your server administrator

    2) Use something other than InnoDB

    3) Use a surrogate key , other than your primary key that is numeric and sequential along with your natural primary key.

    OR

    4) Try this https://stackoverflow.com/a/2223062/3391466.

    评论

报告相同问题?

悬赏问题

  • ¥18 深度学习tensorflow1,ssdv1,coco数据集训练一个模型
  • ¥100 关于注册表摄像头和麦克风的问题
  • ¥30 代码本地运行正常,但是TOMCAT部署时闪退
  • ¥15 关于#python#的问题
  • ¥15 主机可以ping通路由器但是连不上网怎么办
  • ¥15 数据库一张以时间排好序的表中,找出多次相邻的那些行
  • ¥50 关于DynamoRIO处理多线程程序时候的问题
  • ¥15 kubeadm部署k8s出错
  • ¥15 Abaqus打不开cae文件怎么办?
  • ¥15 小程序准备上线,软件开发公司需要提供哪些资料给甲方