diff options
| author | Karen Arutyunov <karen@codesynthesis.com> | 2023-10-11 13:32:34 +0300 |
|---|---|---|
| committer | Karen Arutyunov <karen@codesynthesis.com> | 2023-10-11 13:32:34 +0300 |
| commit | 7b3235be5c837f8ef74f099e5048251aeb17f093 (patch) | |
| tree | e9f76c75dedd47439de9d39f084c55084c33dd52 | |
| parent | 5275715ea7ba476af67ee293b242021b45306638 (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.cxx | 2 | ||||
| -rw-r--r-- | monitor/monitor.cxx | 2 |
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 ()); |