limbo icon indicating copy to clipboard operation
limbo copied to clipboard

Preparing a statement is slower than with SQLite

Open penberg opened this issue 6 months ago • 5 comments

limbo/Prepare statement: 'SELECT 1'
                        time:   [1.4930 µs 1.4949 µs 1.4973 µs]
                        thrpt:  [667.86 Kelem/s 668.94 Kelem/s 669.81 Kelem/s]
                 change:
                        time:   [-1.7708% +0.2245% +1.3879%] (p = 0.84 > 0.05)
                        thrpt:  [-1.3689% -0.2240% +1.8027%]
                        No change in performance detected.

rusqlite/Prepare statement: 'SELECT 1'
                        time:   [487.04 ns 488.81 ns 491.40 ns]
                        thrpt:  [2.0350 Melem/s 2.0458 Melem/s 2.0532 Melem/s]
                 change:
                        time:   [-0.3547% +0.8598% +1.6341%] (p = 0.08 > 0.05)
                        thrpt:  [-1.6079% -0.8525% +0.3560%]
                        No change in performance detected.
Found 4 outliers among 100 measurements (4.00%)
  1 (1.00%) low mild
  2 (2.00%) high mild
  1 (1.00%) high severe

penberg avatar Jul 24 '24 18:07 penberg