Skip to content

Should I tune for throughput or query runtime?

Luigi edited this page Oct 11, 2023 · 3 revisions

With DBtune you can tune configuration parameters either to optimize overall throughput or to optimize the average query runtime. Note that typically, improving one optimization target will also benefit the other target. However, this choice allows the DBtune optimizer to focus on one optimization objective and provide the best solution for that given optimization target. The three benchmarks we have pre-configured can be tuned both for throughput and for average query runtime.

  • Choose throughput if your machine/workload is hitting a bottleneck and, in other words, an increased workload wouldn’t lead to increased overall throughput. This option can help you to increase the overall throughput of your workload.
  • Choose average query runtime if your workload is composed of complex queries and you wish to reduce the average runtime of one query. The query runtime can improve even if the machine/workload is not bottlenecked as intensely.

For more information on which optimization objective to choose please refer to the "How to get started" section in the user guide.