Skip to contents

Benchmark queries against a store

Source: R/store.R
obis_bench.Rd

Times each SQL statement: the first (cold) run and the median of reps further (warm) runs, plus the number of rows returned. Use with obis_bench_queries() for the paper's default set, or any named character vector of SQL.

Usage

obis_bench(con, queries, reps = 3L)

Arguments

con

connection from obis_store_connect().

queries

named character vector of SQL statements (no {{res}} placeholders — bind them first, e.g. via res_placeholder).

reps

number of warm repetitions after the cold run (default 3).

Value

data frame with label, rows, cold_s, warm_s (median).