使用Sqlsugar从130W数据中进行10条每页进行分页,数据库查询需要2S左右 但页面需要4S左右。
SELECT * FROM (SELECT "BuildingRecordsID" AS "BuildingRecordsID" , "CommunityName" AS "CommunityName" , "RegionalismCode" AS "Address" , :constant1 AS "DesignYear" , "BuildingType" AS "BuildingType" , "BuildingStatus" AS "BuildingStatus" , "BuildingConTime" AS "BuildingConTime" , "SafetyLevel" AS "SafetyLevel" , "FlowState" AS "FlowState" , "BuildingChangeStatus" AS "BuildingChangeStatus" , "RegionalismCode" AS "areaCode" , "Town" AS "Town" , "Zu_QG" AS "AGroup" , "Lu_QG" AS "ARoad" , "Hao_QG" AS "ANum" , "Dong_QG" AS "ABuil" , "BezierPoint" AS "BezierPoint" , "Point" AS "Point" , "BuildingHeight" AS "BuildingHeight" , "BuildingArea" AS "BuildingArea" , "DampingType" AS "DampingType" , "ProtectType" AS "ProtectType" , "IsDamage" AS "IsDamage" , "IsReinforced" AS "IsReinforced" , "IndexCloumn" AS "IndexCloumn" ,ROW_NUMBER() OVER( ORDER BY sysdate) AS RowIndex FROM "HOUSE"."HOUSE" WHERE ("RegionalismCode" like :MethodConst0||'%') ) T WHERE RowIndex BETWEEN 1 AND 10
ROW_NUMBER() OVER( ORDER BY sysdate) AS RowIndex 问题点出在了这里的排序上,这个的意义是?业务逻辑是什么,是否可以使用简单的rownum代替