作者共發了18篇帖子。
今天下午,我要重点处理首页速度慢的问题
1樓 巨大八爪鱼 2015-9-2 16:10
通过设立缓存的方式解决
2樓 巨大八爪鱼 2015-9-2 16:11
目前:
<!-- [Information for Stewards] Execution Time: 13.99s -->

3樓 巨大八爪鱼 2015-9-2 23:39
我發現,在mysql中使用了timestamp數據類型後,以前的時區設置已經失效了。

現在已降至10秒了。
<!-- [Information for Stewards] Execution Time: 10.54s -->
4樓 巨大八爪鱼 2015-9-2 23:40
4.33+0.13+0.63 = 5.09
已節省5秒
5樓 巨大八爪鱼 2015-9-2 23:41
今天晚上停工
明天繼續
6樓 巨大八爪鱼 2015-9-3 08:18
今天主要处理首页分类列表缓存,估计还能节省7秒左右
7樓 巨大八爪鱼 2015-9-3 18:31
{"count":1,"1":{"content":"saved","executionTime":0.881,"queued":false,"time":"2015-9-3 10:29:51","user":"1"}}
Total Time: 0.881s
光是電腦數位那個欄目就花費了0.881秒!
8樓 巨大八爪鱼 2015-9-3 18:59
分類模塊的緩存終於弄好了
這是最複雜的一部分!
{"count":15,"1":{"content":"saved","executionTime":0.872,"queued":false,"time":"2015-9-3 10:53:33","user":"1"},"10":{"content":"saved","executionTime":0.862,"queued":false,"time":"2015-9-3 10:55:09","user":"1"},"18":{"content":"saved","executionTime":0.255,"queued":false,"time":"2015-9-3 10:55:18","user":"1"},"21":{"content":"saved","executionTime":0.411,"queued":false,"time":"2015-9-3 10:55:27","user":"1"},"26":{"content":"saved","executionTime":0.5,"queued":false,"time":"2015-9-3 10:55:36","user":"1"},"31":{"content":"saved","executionTime":0.242,"queued":false,"time":"2015-9-3 10:56:07","user":"1"},"39":{"content":"saved","executionTime":0.83,"queued":false,"time":"2015-9-3 10:56:19","user":"1"},"62":{"content":"saved","executionTime":0.276,"queued":false,"time":"2015-9-3 10:56:28","user":"1"},"67":{"content":"saved","executionTime":0.891,"queued":false,"time":"2015-9-3 10:56:39","user":"1"},"81":{"content":"saved","executionTime":0.848,"queued":false,"time":"2015-9-3 10:56:51","user":"1"},"85":{"content":"saved","executionTime":0.249,"queued":false,"time":"2015-9-3 10:57:04","user":"1"},"88":{"content":"saved","executionTime":0.407,"queued":false,"time":"2015-9-3 10:57:18","user":"1"},"91":{"content":"saved","executionTime":0.799,"queued":false,"time":"2015-9-3 10:57:25","user":"1"},"119":{"content":"saved","executionTime":0.009,"queued":false,"time":"2015-9-3 10:57:34","user":"1"},"134":{"content":"saved","executionTime":0.007,"queued":false,"time":"2015-9-3 10:57:44","user":"1"}}
Total Time: 7.458s
這部分節約了大約7.5秒
7.5+5 = 12.5
15 - 12.5 = 2.5
9樓 巨大八爪鱼 2015-9-3 19:00

回復:6樓

7.5秒和我估計的很接近

10樓 巨大八爪鱼 2015-9-3 19:00
目前:
<!-- [Information for Stewards] Execution Time: 0.98s -->

恭喜已經降到了1秒以下!
完工了

回復帖子

內容:
用戶名: 您目前是匿名發表
驗證碼:
 
 
©2010-2024 Arslanbar [手機版] [桌面版]
除非另有聲明,本站採用創用CC姓名標示-相同方式分享 3.0 Unported許可協議進行許可。