Issue

管理画面 dau分析が重い #1942

kouho opened this at 2022-06-09T18:41:11; closed

Description

opened by kouho at 2022-06-09T18:41:11; updated 2022-06-16T17:40:35
優先度たかめにしてほしいとの要望
wada change_priority at 2022-06-10T10:42:57: 未分類:important
wada change_priority at 2022-06-10T10:42:59: important:high

Comment

#19934 by wada at 2022-06-10T12:27:34; updated 2022-06-10T12:27:34

whileが時間かかりすぎ

#m_dau_analysis_ajax.inc
	$sqlSt = sprintf("
		SELECT
			`date`,`user_no`
		FROM
			`dau_login`
		WHERE
			`date` >= '%s'
		AND
			`date` < '%s'
		AND
			`login_count` >= 30
		AND
			`straight_day` >= 5
		ORDER BY
			`date` ASC"
		, $time1
		, $time2
		);
	$rs = S_Query( $sqlSt, $_dbc[37], 1 );
	$fu_fpu_data_array = array();
	while($sqlResult = mysql_fetch_array($rs)){
		if( isset($fpu_user[$sqlResult['date']]) ){
			if( in_array($sqlResult['user_no'], $fpu_user[$sqlResult['date']]) ){
				$fu_fpu_data_array[$sqlResult['date']] += 1;
			}
		}else{
			continue;
		}
	}

Comment

#19942 by wada at 2022-06-10T20:09:00; updated 2022-06-10T20:09:00

待ち時間を減らすため、いったんFU_FPUの処理をコメントアウト

wada assign at 2022-06-16T16:57:18: Not assigned:wada
wada close at 2022-06-16T17:40:35: Close