--------------------------------------------------------- Artifactory with the fix with 201,001 artifacts (wonderful_vaughan) curl -uadmin:password 'localhost:8081/artifactory/api/search/prop?a=1&b=763736&repos=example-repo-local' 172.82 162.13 219.55 185.34 192.93 190.96 174.57 181.42 186.51 166.77 2018-12-04 14:39:43,413 [http-nio-8081-exec-24] [DEBUG] (o.j.s.JdbcHelper :178) - Query returned in 172.82 millis : 'select distinct n.repo as itemRepo,n.node_path as itemPath,n.node_name as itemName,n.created as itemCreated,n.modified as itemModified,n.updated as itemUpdated,n.created_by as itemCreatedBy,n.modified_by as itemModifiedBy,n.node_type as itemType,n.bin_length as itemSize,n.node_id as itemId,n.depth as itemDepth,n.sha1_actual as itemActualSha1,n.sha1_original as itemOriginalSha1,n.md5_actual as itemActualMd5,n.md5_original as itemOriginalMd5,n.sha256 as itemSha2 from nodes n left outer join node_props np100 on np100.node_id = n.node_id left outer join node_props np101 on np101.node_id = n.node_id where (( n.repo = 'example-repo-local') and(( np100.prop_key = 'a' and np100.prop_value = '1')) and(( np101.prop_key = 'b' and np101.prop_value = '763736'))) ' curl -uadmin:password 'localhost:8081/artifactory/api/search/aql' --data 'items.find({"@a" : {"$eq" : "1"}}, {"@b" : {"$eq" : "763736"}}).include("path", "name")' -H"Content-Type:text/plain" 351.56 247.67 247.63 253.17 271.68 283.6 250.6 289.19 251.28 244.11 2018-12-04 14:44:05,460 [http-nio-8081-exec-47] [DEBUG] (o.j.s.JdbcHelper :178) - Query returned in 273.96 millis : 'select distinct n.node_path as itemPath,n.node_name as itemName from nodes n left outer join node_props np100 on np100.node_id = n.node_id left outer join node_props np101 on np101.node_id = n.node_id where (( np100.prop_key = 'a' and np100.prop_value = '1') and( np101.prop_key = 'b' and np101.prop_value = '763736') and n.node_type = 1) and(n.repo != 'auto-trashcan' or n.repo is null) ' curl -uadmin:password 'localhost:8081/artifactory/api/search/aql' --data 'items.find({"@a" : {"$eq" : "1"}}, {"@b" : {"$eq" : "763736"}}).include("path", "name").limit(100000)' -H"Content-Type:text/plain" 254.92 269.95 264.94 264.96 277.69 321.5 279.19 273.89 240.98 289.45 2018-12-04 14:47:18,253 [http-nio-8081-exec-22] [DEBUG] (o.j.s.JdbcHelper :178) - Query returned in 273.69 millis : 'Select top 100000 * From (select distinct n.node_path as itemPath,n.node_name as itemName from nodes n left outer join node_props np100 on np100.node_id = n.node_id left outer join node_props np101 on np101.node_id = n.node_id where (( np100.prop_key = 'a' and np100.prop_value = '1') and( np101.prop_key = 'b' and np101.prop_value = '763736') and n.node_type = 1) and(n.repo != 'auto-trashcan' or n.repo is null) ) aa ' curl -uadmin:password 'localhost:8081/artifactory/api/search/aql' --data 'items.find({"@a" : {"$eq" : "1"}}, {"@b" : {"$eq" : "763736"}}).include("path", "name").offset(20000).limit(100000)' -H"Content-Type:text/plain" 151.83 168.32 182.39 183.47 169.44 168.18 212.48 177.02 160.92 190.92 2018-12-04 14:51:09,136 [http-nio-8081-exec-44] [DEBUG] (o.j.s.JdbcHelper :178) - Query returned in 162.78 millis : 'Select bb.* From (Select aa.* ,ROW_NUMBER() OVER ( order by (SELECT 1)) AS RN from ( select distinct n.node_path as itemPath,n.node_name as itemName from nodes n left outer join node_props np100 on np100.node_id = n.node_id left outer join node_props np101 on np101.node_id = n.node_id where (( np100.prop_key = 'a' and np100.prop_value = '1') and( np101.prop_key = 'b' and np101.prop_value = '763736') and n.node_type = 1) and(n.repo != 'auto-trashcan' or n.repo is null) ) aa ) bb Where bb.RN >= 20001 AND bb.RN < 120001 ' --------------------------------------------------------- Old Artifactory with 197,745 artifacts curl -uadmin:password 'localhost:8081/artifactory/api/search/prop?a=1&b=763736&repos=example-repo-local' 3.56 6.68 4.77 2.6 4.31 4.28 3.83 4.18 4.79 3.85 2018-12-04 15:43:25,720 [http-nio-8081-exec-10] [DEBUG] (o.j.s.JdbcHelper :178) - Query returned in 3.14 millis : 'Select bb.* from (Select aa.* ,ROW_NUMBER() OVER ( order by (SELECT 1)) AS RN from ( select distinct n.repo as itemRepo,n.node_path as itemPath,n.node_name as itemName,n.created as itemCreated,n.modified as itemModified,n.updated as itemUpdated,n.created_by as itemCreatedBy,n.modified_by as itemModifiedBy,n.node_type as itemType,n.bin_length as itemSize,n.node_id as itemId,n.depth as itemDepth,n.sha1_actual as itemActualSha1,n.sha1_original as itemOriginalSha1,n.md5_actual as itemActualMd5,n.md5_original as itemOriginalMd5,n.sha256 as itemSha2 from nodes n left outer join node_props np100 on np100.node_id = n.node_id left outer join node_props np101 on np101.node_id = n.node_id where (( n.repo = 'example-repo-local') and(( np100.prop_key = 'a' and np100.prop_value = '1')) and(( np101.prop_key = 'b' and np101.prop_value = '763736'))) ) aa ) bb Where bb.RN >= 1 AND bb.RN < 2147483648 ' galba-mac:testfiles galba$ curl -uadmin:password 'localhost:8081/artifactory/api/search/aql' --data 'items.find({"@a" : {"$eq" : "1"}}, {"@b" : {"$eq" : "763736"}}).include("path", "name")' -H"Content-Type:text/plain" 334.89 317.6 322.89 319.05 338.44 328.26 380.4 313.01 362.15 291.5 2018-12-04 15:49:20,846 [http-nio-8081-exec-7] [DEBUG] (o.j.s.JdbcHelper :178) - Query returned in 314.11 millis : 'select distinct n.node_path as itemPath,n.node_name as itemName from nodes n left outer join node_props np100 on np100.node_id = n.node_id left outer join node_props np101 on np101.node_id = n.node_id where (( np100.prop_key = 'a' and np100.prop_value = '1') and( np101.prop_key = 'b' and np101.prop_value = '763736') and n.node_type = 1) and(n.repo != 'auto-trashcan' or n.repo is null) ' curl -uadmin:password 'localhost:8081/artifactory/api/search/aql' --data 'items.find({"@a" : {"$eq" : "1"}}, {"@b" : {"$eq" : "763736"}}).include("path", "name").limit(100000)' -H"Content-Type:text/plain" 114.2 125.42 112.51 129.76 138.29 132.21 122.76 120.79 120.92 124.35 2018-12-04 15:56:22,678 [http-nio-8081-exec-5] [DEBUG] (o.j.s.JdbcHelper :178) - Query returned in 188.36 millis : 'Select bb.* from (Select aa.* ,ROW_NUMBER() OVER ( order by (SELECT 1)) AS RN from ( select distinct n.node_path as itemPath,n.node_name as itemName from nodes n left outer join node_props np100 on np100.node_id = n.node_id left outer join node_props np101 on np101.node_id = n.node_id where (( np100.prop_key = 'a' and np100.prop_value = '1') and( np101.prop_key = 'b' and np101.prop_value = '763736') and n.node_type = 1) and(n.repo != 'auto-trashcan' or n.repo is null) ) aa ) bb Where bb.RN >= 1 AND bb.RN < 100001 ' curl -uadmin:password 'localhost:8081/artifactory/api/search/aql' --data 'items.find({"@a" : {"$eq" : "1"}}, {"@b" : {"$eq" : "763736"}}).include("path", "name").offset(20000).limit(100000)' -H"Content-Type:text/plain" 199.7 167.89 187.29 164.13 167.68 185.14 174.51 164.38 158.95 178.05 2018-12-04 16:01:51,111 [http-nio-8081-exec-6] [DEBUG] (o.j.s.JdbcHelper :178) - Query returned in 178.05 millis : 'Select bb.* from (Select aa.* ,ROW_NUMBER() OVER ( order by (SELECT 1)) AS RN from ( select distinct n.node_path as itemPath,n.node_name as itemName from nodes n left outer join node_props np100 on np100.node_id = n.node_id left outer join node_props np101 on np101.node_id = n.node_id where (( np100.prop_key = 'a' and np100.prop_value = '1') and( np101.prop_key = 'b' and np101.prop_value = '763736') and n.node_type = 1) and(n.repo != 'auto-trashcan' or n.repo is null) ) aa ) bb Where bb.RN >= 20001 AND bb.RN < 120001 '