Settings | Sign in | Sign up

The author has 18 posts.

今天下午,我要重点处理首页速度慢的问题

Floor 1 巨大八爪鱼 9/2/15 16:10
通过设立缓存的方式解决
Floor 2 巨大八爪鱼 9/2/15 16:11
目前:
<!-- [Information for Stewards] Execution Time: 13.99s -->

Floor 3 巨大八爪鱼 9/2/15 23:39
我发现,在mysql中使用了timestamp数据类型后,以前的时区设置已经失效了。

现在已降至10秒了。
<!-- [Information for Stewards] Execution Time: 10.54s -->
Floor 4 巨大八爪鱼 9/2/15 23:40
4.33+0.13+0.63 = 5.09
已节省5秒
Floor 5 巨大八爪鱼 9/2/15 23:41
今天晚上停工
明天继续
Floor 6 巨大八爪鱼 9/3/15 8:18
今天主要处理首页分类列表缓存,估计还能节省7秒左右
Floor 7 巨大八爪鱼 9/3/15 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秒!
Floor 8 巨大八爪鱼 9/3/15 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
Floor 9 巨大八爪鱼 9/3/15 19:00

回复:6楼

7.5秒和我估计的很接近

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

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

Content converter:

Reply the post
Content:
User: You are currently anonymous.
Captcha:
Unclear? Try another one.