1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
|
//
// 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>
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");
// Ensure that nothing gets optimized away
unsigned num_rows = 0;
// Benchmark starts here
auto tbegin = std::chrono::steady_clock::now();
// 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 many rows
return num_rows == 0 ? EXIT_FAILURE : EXIT_SUCCESS;
}
|
