dongyimo1293 2013-11-01 16:08
浏览 40

环境之间的SQL执行时间变化

We have a PHP web interface which calls a stored procedure which is taking excessively long on our live environment. I have restored all our information to the DEV env to replicate but it seems that the query takes less that a few seconds to complete on dev what takes atleast 90 seconds on live. I am out of ideas as to how this could be. Also, viewing the activity monitor on live env shows that it flags the procedure call as an expensive query but not on DEV. Does anyone have any useful insight into this variation in execution times between Environments for the same data? Both php versions are the same as well as the data within the databases. There is no resource governor on either database dictating priority based on user groups either. I'm out of Ideas, any help is appreciated, Thanks.

  • 写回答

0条回答 默认 最新

    报告相同问题？

    悬赏问题

    • ¥15 华为ensp模拟器中S5700交换机在配置过程中老是反复重启
    • ¥15 java写代码遇到问题，求帮助
    • ¥15 uniapp uview http 如何实现统一的请求异常信息提示？
    • ¥15 有了解d3和topogram.js库的吗？有偿请教
    • ¥100 任意维数的K均值聚类
    • ¥15 stamps做sbas-insar，时序沉降图怎么画
    • ¥15 买了个传感器，根据商家发的代码和步骤使用但是代码报错了不会改，有没有人可以看看
    • ¥15 关于#Java#的问题，如何解决？
    • ¥15 加热介质是液体，换热器壳侧导热系数和总的导热系数怎么算
    • ¥100 嵌入式系统基于PIC16F882和热敏电阻的数字温度计