Add perf test over DB SQL select complex

1 files changed, 24 insertions, 0 deletions

diff --git a/slicer/db/testPerf.cpp b/slicer/db/testPerf.cpp
new file mode 100644
index 0000000..2f98cd2
--- /dev/null
+++ b/slicer/db/testPerf.cpp
@@ -0,0 +1,24 @@
+#include "sqlSelectDeserializer.h"
+#include "testMockCommon.h"
+#include <benchmark/benchmark.h>
+#include <connection.h>
+#include <definedDirs.h>
+#include <slicer/slicer.h>
+#include <testModels.h>
+
+const StandardMockDatabase db;
+
+class CoreFixture : public benchmark::Fixture, public ConnectionFixture { };
+
+BENCHMARK_F(CoreFixture, bulk_select_complex)(benchmark::State & state)
+{
+	auto sel = db->select(R"SQL(
+			SELECT s mint, CAST(s AS NUMERIC(7,1)) mdouble, CAST(s as text) mstring, s % 2 = 0 mbool
+			FROM GENERATE_SERIES(1, 10000) s)SQL");
+	for (auto _ : state) {
+		benchmark::DoNotOptimize(
+				Slicer::DeserializeAny<Slicer::SqlSelectDeserializer, TestDatabase::BuiltInSeq>(sel.get()));
+	}
+}
+
+BENCHMARK_MAIN();