Discuz Q 回复非常卡临时解决方案
文章摘要
DaoGPT
分析故障原因：因为Discuzq每次发帖或回复都会统计一次，post表过大的情况下，会卡住 临时解决方法：文件路径 \app\Observer\PostObserver.php 内搜索“刷新站点回复数”/*** 刷新站点回复数*/ private function refreshSitePostCount() { $this->settings->set( 'post_count', Post::query() &...
此内容根据文章AI生成，并经过人工审核，仅用于文章内容的解释与总结
投诉分析故障原因：因为discuzq每次发帖或回复都会统计一次，post表过大的情况下，会卡住
临时解决方法：
文件路径 \app\Observer\PostObserver.php 内搜索“刷新站点回复数”
/**
* 刷新站点回复数
*/
private function refreshSitePostCount()
{
$this->settings->set(
'post_count',
Post::query()
->where('is_approved', Post::APPROVED)
->whereNull('deleted_at')
->whereNotNull('user_id')
->count()
);
}修改为
/**
* 刷新站点回复数
*/
private function refreshSitePostCount()
{
$cache = app('cache');
$cacheKey = 'post_count';
$red_cache = $cache->GET($cacheKey);
if(empty($red_cache)){
$cache->put($cacheKey, Post::query()
->where('is_approved', Post::APPROVED)
->whereNull('deleted_at')
->whereNotNull('user_id')
->count(),86400);
}
$this->settings->set(
'post_count',
$red_cache
);
}文件路径 \app\Observer\ThreadObserver.php 搜索“刷新站点主题数”
/**
* 刷新站点主题数
*/
private function refreshSiteThreadCount()
{
$this->settings->set(
'thread_count',
Thread::query()
->where('is_approved', Thread::APPROVED)
->whereNull('deleted_at')
->whereNotNull('user_id')
->count()
);
}修改为
/**
* 刷新站点主题数
*/
private function refreshSiteThreadCount()
{
$cache = app('cache');
$cacheKey = 'thread_count';
$red_cache = $cache->GET($cacheKey);
if(empty($red_cache)){
$cache->put($cacheKey, Thread::query()
->where('is_approved', Thread::APPROVED)
->whereNull('deleted_at')
->whereNotNull('user_id')
->count(),86400);
}
$this->settings->set(
'thread_count',
$red_cache
);
}更新缓存，故障解决
打赏
微信扫一扫，打赏作者吧～
微信扫一扫，打赏作者吧～
