代码拉取完成,页面将自动刷新
两万多条数据分页查询就用了接近20秒,页数越大越慢。
1.
SELECT TOP
20 "corpCode",
"corpName",
"id",
"logType",
"logTitle",
"createBy",
"createByName",
"createDate",
"requestUri",
"requestMethod",
"requestParams",
"diffModifyData",
"bizKey",
"bizType",
"remoteAddr",
"serverAddr",
"isException",
"exceptionInfo",
"userAgent",
"deviceName",
"browserName",
"executeTime"
FROM
(
SELECT
ROW_NUMBER () OVER ( ORDER BY "createDate" DESC ) PAGE_ROW_NUMBER,
"corpCode",
"corpName",
"id",
"logType",
"logTitle",
"createBy",
"createByName",
"createDate",
"requestUri",
"requestMethod",
"requestParams",
"diffModifyData",
"bizKey",
"bizType",
"remoteAddr",
"serverAddr",
"isException",
"exceptionInfo",
"userAgent",
"deviceName",
"browserName",
"executeTime"
FROM
(
SELECT
a.corp_code AS "corpCode",
a.corp_name AS "corpName",
a.id AS "id",
a.log_type AS "logType",
a.log_title AS "logTitle",
a.create_by AS "createBy",
a.create_by_name AS "createByName",
a.create_date AS "createDate",
a.request_uri AS "requestUri",
a.request_method AS "requestMethod",
a.request_params AS "requestParams",
a.diff_modify_data AS "diffModifyData",
a.biz_key AS "bizKey",
a.biz_type AS "bizType",
a.remote_addr AS "remoteAddr",
a.server_addr AS "serverAddr",
a.is_exception AS "isException",
a.exception_info AS "exceptionInfo",
a.user_agent AS "userAgent",
a.device_name AS "deviceName",
a.browser_name AS "browserName",
a.execute_time AS "executeTime"
FROM
js_sys_log a
WHERE
a.log_type = 'loginLogout'
) AS PAGE_TABLE_ALIAS
) AS PAGE_TABLE_ALIAS
WHERE
PAGE_ROW_NUMBER > 29640
ORDER BY
PAGE_ROW_NUMBER
这里贴错误信息