aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKaren Arutyunov <karen@codesynthesis.com>2023-10-11 13:32:34 +0300
committerKaren Arutyunov <karen@codesynthesis.com>2023-10-11 13:32:34 +0300
commit7b3235be5c837f8ef74f099e5048251aeb17f093 (patch)
treee9f76c75dedd47439de9d39f084c55084c33dd52
parent5275715ea7ba476af67ee293b242021b45306638 (diff)
To improve bdep-clean and bdep-monitor performance increase LIMIT clause value in their SELECT queries from 100 to 2000
-rw-r--r--clean/clean.cxx2
-rw-r--r--monitor/monitor.cxx2
2 files changed, 2 insertions, 2 deletions
diff --git a/clean/clean.cxx b/clean/clean.cxx
index 59084d3..55fb59b 100644
--- a/clean/clean.cxx
+++ b/clean/clean.cxx
@@ -285,7 +285,7 @@ namespace brep
bld_query::id.toolchain_name +
order_by_version (bld_query::id.toolchain_version,
false /* first */) +
- "OFFSET" + bld_query::_ref (offset) + "LIMIT 100");
+ "OFFSET" + bld_query::_ref (offset) + "LIMIT 2000");
connection_ptr conn (db.connection ());
diff --git a/monitor/monitor.cxx b/monitor/monitor.cxx
index 126650c..6d6bb99 100644
--- a/monitor/monitor.cxx
+++ b/monitor/monitor.cxx
@@ -538,7 +538,7 @@ namespace brep
query::id.toolchain_name +
order_by_version (query::id.toolchain_version,
false /* first */) +
- "OFFSET" + query::_ref (offset) + "LIMIT 100");
+ "OFFSET" + query::_ref (offset) + "LIMIT 2000");
connection_ptr conn (db.connection ());