mirror of
https://github.com/boostorg/mysql.git
synced 2025-05-12 14:11:41 +00:00
303b9f0b59
Added one_small_row, one_big_row, many_rows, stmt_params benchmarks against libmysqlclient and libmariadb Added a CI build to compile and run benchmarks Added a Python script to run the benchmarks Refactored the connection_pool benchmark to be use data independent from examples close #458
67 lines
1.9 KiB
C++
67 lines
1.9 KiB
C++
//
|
|
// Copyright (c) 2019-2025 Ruben Perez Hidalgo (rubenperez038 at gmail dot com)
|
|
//
|
|
// Distributed under the Boost Software License, Version 1.0. (See accompanying
|
|
// file LICENSE_1_0.txt or copy at http://www.boost.org/LICENSE_1_0.txt)
|
|
//
|
|
|
|
#include <boost/mysql/any_connection.hpp>
|
|
#include <boost/mysql/connect_params.hpp>
|
|
#include <boost/mysql/execution_state.hpp>
|
|
#include <boost/mysql/results.hpp>
|
|
#include <boost/mysql/ssl_mode.hpp>
|
|
|
|
#include <boost/asio/io_context.hpp>
|
|
|
|
#include <cassert>
|
|
#include <chrono>
|
|
#include <cstdlib>
|
|
#include <cstring>
|
|
#include <iostream>
|
|
|
|
using namespace std;
|
|
|
|
namespace asio = boost::asio;
|
|
namespace mysql = boost::mysql;
|
|
|
|
int main()
|
|
{
|
|
// Setup
|
|
asio::io_context ctx;
|
|
mysql::any_connection conn(ctx);
|
|
mysql::execution_state st;
|
|
|
|
// Connect
|
|
mysql::connect_params params;
|
|
params.server_address.emplace_unix_path("/var/run/mysqld/mysqld.sock");
|
|
params.username = "root";
|
|
params.password = "";
|
|
params.database = "boost_mysql_bench";
|
|
params.ssl = mysql::ssl_mode::disable;
|
|
conn.connect(params);
|
|
|
|
// Prepare the statement
|
|
auto stmt = conn.prepare_statement("SELECT * FROM test_data WHERE id = 1");
|
|
|
|
// Ensure that nothing gets optimized away
|
|
unsigned num_rows = 0;
|
|
|
|
// Benchmark starts here
|
|
auto tbegin = std::chrono::steady_clock::now();
|
|
|
|
for (int i = 0; i < 10000; ++i)
|
|
{
|
|
// start_execution won't copy the strings in the rows (as opposed to execute),
|
|
// so it's preferable when we have big rows, like here
|
|
conn.start_execution(stmt.bind(), st);
|
|
while (!st.complete())
|
|
num_rows += conn.read_some_rows(st).size();
|
|
}
|
|
|
|
// Benchmark ends here
|
|
auto tend = std::chrono::steady_clock::now();
|
|
std::cout << std::chrono::duration_cast<std::chrono::milliseconds>(tend - tbegin).count() << std::endl;
|
|
|
|
// We expect one row per iteration
|
|
return num_rows == 10000 ? EXIT_SUCCESS : EXIT_FAILURE;
|
|
} |