Issue

冒険負荷対策 #4417

wada opened this at 2025-12-10T11:04:21; open

Description

opened by wada at 2025-12-10T11:04:21; updated 2026-02-04T10:06:36

夜会CP中のDBサーバーに対する継続的な高負荷に対する対策
CPの仕様調整による解決は考慮しない

> DBサーバー側のスペックアップは現状考えれない。
負荷要因でMYSQLのSELECTコマンドの多さが原因のため、その時メインで必要でない部分のSELECTを減らすことが大切。

Comment

#43464 by wada at 2025-12-10T11:05:55; updated 2025-12-10T11:05:55

Mission.inc(クエリ発行)

if (S_IsWarShipDeckExists($user_info['user_no'])) {
$user_valhalla = S_GetUserValhalla($user_info['user_no']);
$team_quest_class = S_LoadModelClass('Team_quest_factory')->create_class();
$_temp['team_quest_info'] = $team_quest_class->get_display_info($user_info['team_no'], $user_info['user_no']);
$user_mission = S_GetUserMission($user_info['user_no']);
$team_data = S_GetTeamData($user_info['team_no']);
$user_item = S_GetUserItem($user_info['user_no'],$select_item_list);
$sp_free = SeasonPass::getInstance()->get_free_compass_info();
$_temp['MasterStarterPack'] = S_GetUserMasterStarterPack($user_info['user_no']);
$_temp['war_ship_deck_exists'] = S_IsWarShipDeckExists($user_info['user_no'], $user_info['battle_deck']);
$card_texts = S_GetCardText($card_list);
$card_master = S_GetCardMaster($card_list);
wada refer at 2026-02-04T10:06:36: 4497:【2/6】冒険のselect回数削減