[性能测试] 接口性能测试

[wklken]

大数据集的场景下, 前端页面/后台接口是否有问题

[wklken]

首页加载不出来, 原因: 根路径下部门过多没有分页?

问题: 如果某个目录下的一级部门列表过大(level=0), 例如 6000 个, 那么首页加载会挂

[wklken]

/api/v2/departments/ 放大查询

DEBUG [2022-10-13 17:59:20,684] (0.002) SELECT COUNT(*) AS `__count` FROM `departments_department` WHERE `departments_department`.`enabled`; args=()
DEBUG [2022-10-13 17:59:20,688] (0.003) SELECT `departments_department`.`id`, `departments_department`.`create_time`, `departments_department`.`update_time`, `departments_department`.`name`, `departments_department`.`code`, `departments_department`.`parent_id`, `departments_department`.`order`, `departments_department`.`enabled`, `departments_department`.`extras`, `departments_department`.`category_id`, `departments_department`.`lft`, `departments_department`.`rght`, `departments_department`.`tree_id`, `departments_department`.`level` FROM `departments_department` WHERE `departments_department`.`enabled` ORDER BY `departments_department`.`id` ASC LIMIT 50; args=()
DEBUG [2022-10-13 17:59:20,692] (0.000) SELECT (1) AS `a` FROM `departments_department` WHERE (`departments_department`.`parent_id` = 1 AND `departments_department`.`enabled`) LIMIT 1; args=(1,)
DEBUG [2022-10-13 17:59:20,694] (0.000) SELECT (1) AS `a` FROM `departments_department` WHERE (`departments_department`.`parent_id` = 4 AND `departments_department`.`enabled`) LIMIT 1; args=(4,)
DEBUG [2022-10-13 17:59:20,695] (0.000) SELECT `departments_department`.`name` FROM `departments_department` WHERE (`departments_department`.`lft` <= 7 AND `departments_department`.`rght` >= 10 AND `departments_department`.`tree_id` = 1) ORDER BY `departments_department`.`lft` ASC; args=(7, 10, 1)
DEBUG [2022-10-13 17:59:20,696] (0.000) SELECT (1) AS `a` FROM `departments_department` WHERE (`departments_department`.`parent_id` = 208 AND `departments_department`.`enabled`) LIMIT 1; args=(208,)
DEBUG [2022-10-13 17:59:20,697] (0.000) SELECT (1) AS `a` FROM `departments_department` WHERE (`departments_department`.`parent_id` = 211 AND `departments_department`.`enabled`) LIMIT 1; args=(211,)
DEBUG [2022-10-13 17:59:20,699] (0.000) SELECT `departments_department`.`name` FROM `departments_department` WHERE (`departments_department`.`lft` <= 8 AND `departments_department`.`rght` >= 9 AND `departments_department`.`tree_id` = 1) ORDER BY `departments_department`.`lft` ASC; args=(8, 9, 1)
DEBUG [2022-10-13 17:59:20,700] (0.000) SELECT `departments_department`.`name` FROM `departments_department` WHERE (`departments_department`.`lft` <= 4 AND `departments_department`.`rght` >= 5 AND `departments_department`.`tree_id` = 88) ORDER BY `departments_department`.`lft` ASC; args=(4, 5, 88)
DEBUG [2022-10-13 17:59:20,701] (0.000) SELECT `departments_department`.`name` FROM `departments_department` WHERE (`departments_department`.`lft` <= 148 AND `departments_department`.`rght` >= 149 AND `departments_department`.`tree_id` = 4) ORDER BY `departments_department`.`lft` ASC; args=(148, 149, 4)
DEBUG [2022-10-13 17:59:20,702] (0.000) SELECT (1) AS `a` FROM `departments_department` WHERE (`departments_department`.`parent_id` = 252 AND `departments_department`.`enabled`) LIMIT 1; args=(252,)
DEBUG [2022-10-13 17:59:20,703] (0.000) SELECT (1) AS `a` FROM `departments_department` WHERE (`departments_department`.`parent_id` = 253 AND `departments_department`.`enabled`) LIMIT 1; args=(253,)
DEBUG [2022-10-13 17:59:20,704] (0.000) SELECT (1) AS `a` FROM `departments_department` WHERE (`departments_department`.`parent_id` = 254 AND `departments_department`.`enabled`) LIMIT 1; args=(254,)
DEBUG [2022-10-13 17:59:20,706] (0.000) SELECT `departments_department`.`name` FROM `departments_department` WHERE (`departments_department`.`lft` <= 2 AND `departments_department`.`rght` >= 17 AND `departments_department`.`tree_id` = 122) ORDER BY `departments_department`.`lft` ASC; args=(2, 17, 122)
DEBUG [2022-10-13 17:59:20,707] (0.000) SELECT (1) AS `a` FROM `departments_department` WHERE (`departments_department`.`parent_id` = 255 AND `departments_department`.`enabled`) LIMIT 1; args=(255,)
DEBUG [2022-10-13 17:59:20,708] (0.000) SELECT `departments_department`.`name` FROM `departments_department` WHERE (`departments_department`.`lft` <= 3 AND `departments_department`.`rght` >= 6 AND `departments_department`.`tree_id` = 122) ORDER BY `departments_department`.`lft` ASC; args=(3, 6, 122)
DEBUG [2022-10-13 17:59:20,709] (0.000) SELECT (1) AS `a` FROM `departments_department` WHERE (`departments_department`.`parent_id` = 256 AND `departments_department`.`enabled`) LIMIT 1; args=(256,)
DEBUG [2022-10-13 17:59:20,710] (0.000) SELECT `departments_department`.`name` FROM `departments_department` WHERE (`departments_department`.`lft` <= 4 AND `departments_department`.`rght` >= 5 AND `departments_department`.`tree_id` = 122) ORDER BY `departments_department`.`lft` ASC; args=(4, 5, 122)
DEBUG [2022-10-13 17:59:20,711] (0.000) SELECT `departments_department`.`name` FROM `departments_department` WHERE (`departments_department`.`lft` <= 7 AND `departments_department`.`rght` >= 16 AND `departments_department`.`tree_id` = 122) ORDER BY `departments_department`.`lft` ASC; args=(7, 16, 122)
DEBUG [2022-10-13 17:59:20,713] (0.000) SELECT (1) AS `a` FROM `departments_department` WHERE (`departments_department`.`parent_id` = 264 AND `departments_department`.`enabled`) LIMIT 1; args=(264,)
DEBUG [2022-10-13 17:59:20,714] (0.000) SELECT `departments_department`.`name` FROM `departments_department` WHERE (`departments_department`.`lft` <= 8 AND `departments_department`.`rght` >= 15 AND `departments_department`.`tree_id` = 122) ORDER BY `departments_department`.`lft` ASC; args=(8, 15, 122)

[wklken]

/api/v2/profiles/ 用户属于同一个部门会反复拼接full_name, 次数=page_size

DEBUG [2022-10-13 18:05:02,306] (0.000) SELECT `departments_department`.`name` FROM `departments_department` WHERE (`departments_department`.`lft` <= 4 AND `departments_department`.`rght` >= 5 AND `departments_department`.`tree_id` = 122) ORDER BY `departments_department`.`lft` ASC; args=(4, 5, 122)
DEBUG [2022-10-13 18:05:02,308] (0.000) SELECT `departments_department`.`name` FROM `departments_department` WHERE (`departments_department`.`lft` <= 4 AND `departments_department`.`rght` >= 5 AND `departments_department`.`tree_id` = 122) ORDER BY `departments_department`.`lft` ASC; args=(4, 5, 122)
DEBUG [2022-10-13 18:05:02,310] (0.000) SELECT `departments_department`.`name` FROM `departments_department` WHERE (`departments_department`.`lft` <= 4 AND `departments_department`.`rght` >= 5 AND `departments_department`.`tree_id` = 122) ORDER BY `departments_department`.`lft` ASC; args=(4, 5, 122)
DEBUG [2022-10-13 18:05:02,312] (0.000) SELECT `departments_department`.`name` FROM `departments_department` WHERE (`departments_department`.`lft` <= 4 AND `departments_department`.`rght` >= 5 AND `departments_department`.`tree_id` = 122) ORDER BY `departments_department`.`lft` ASC; args=(4, 5, 122)