回复详情

s80022

2016-7-23 0

@admin
我的意思是那些语法可以用类似的方式对较多数据的用户减少整体消耗,不是单单指搜索。

(例如可以增加个判断或后台增加开关,对于百万数据的论坛,

如果某主题的View大于如十万多少,就不触发UPDATE "views" + 1 ,
然后hy_thread对于超过十万的就直接改显示"形容很多"或是约略的"十万以上",
毕竟每个增加views累积起来也是小负担,而且我看一下常常都0.X s以上,有时候还会突然暴增延时。。)


另外想问一下,atime是指发文时间?
可不可以提示一下修改位置可以暂时注解掉不显示看看是否会顺畅许多? 


还有好像 s & ms 单位很多是错的,另外HY_SQL.php的修复好像没放入1.4.0.7更新中。


SQL查询 (19)

连接数据库 [耗时] 0.0005ms

SELECT * FROM "hy_user" WHERE "id" = '1' LIMIT 1 [耗时] 0.0006ms

SELECT * FROM "hy_forum" [耗时] 0.009ms

SELECT * FROM "hy_usergroup" [耗时] 0.0011ms

SELECT COUNT(*) FROM "hy_post" [耗时] 0.0003ms

SELECT COUNT(*) FROM "hy_thread" [耗时] 0.0002ms

SELECT COUNT(*) FROM "hy_user" [耗时] 0.0004ms

SELECT COUNT(*) FROM "hy_thread" WHERE "atime" > 1469203200 [耗时] 1.1677ms

SELECT COUNT(*) FROM "hy_post" WHERE "atime" > 1469203200 [耗时] 11.686ms

SELECT COUNT(*) FROM "hy_user" WHERE "atime" > 1469203200 [耗时] 0.0241ms

SELECT COUNT(*) FROM "hy_ol" [耗时] 0.0014ms

DELETE FROM "hy_ol" WHERE "atime" < 1469281125 [耗时] 0.0005ms

SELECT COUNT(*) FROM "hy_ol" [耗时] 0.0003ms

SELECT * FROM "hy_thread" WHERE "id" = 620519 LIMIT 1 [耗时] 0.0255ms

SELECT "user" FROM "hy_user" WHERE "id" = '1' LIMIT 1 [耗时] 0.0005ms

SELECT * FROM "hy_post" WHERE "tid" = 620519 AND "isthread" = 1 LIMIT 1 [耗时] 0.01ms

SELECT * FROM "hy_post" WHERE "tid" = 620519 AND "isthread" = 0 ORDER BY "id" LIMIT 0,10 [耗时] 0.0008ms

SELECT * FROM "hy_fileinfo" WHERE "tid" = 620519 [耗时] 0.0343ms

SELECT EXISTS(SELECT 1 FROM "hy_post" WHERE "uid" = '1' AND "tid" = 620519) [耗时] 0.0021ms

UPDATE "hy_thread" SET "views" = "views" + 1 WHERE "id" = 620519 [耗时] 0.8899ms

加载更多

登陆后才可发表内容