turso icon indicating copy to clipboard operation
turso copied to clipboard

`ORDER BY` is much slower compared to SQLite

Open penberg opened this issue 1 year ago • 1 comments

Limbo uses 14x the CPU:

penberg@vonneumann limbo % /usr/bin/time target/release/limbo testing/testing.db "SELECT id FROM users ORDER BY zipcode"
        0,15 real         0,14 user         0,01 sys

in comparison to SQLite:

penberg@vonneumann limbo % /usr/bin/time sqlite3 testing/testing.db "SELECT id FROM users ORDER BY zipcode"
        0,05 real         0,01 user         0,01 sys

penberg avatar Jul 21 '24 17:07 penberg

Likely https://github.com/penberg/limbo/issues/203

penberg avatar Jul 22 '24 16:07 penberg

No significant difference as of e1c8c676ca21490ec36ff13fb921db808861cd00:

        0.01 real         0.01 user         0.00 sys
limbo % /usr/bin/time target/release/tursodb --output-mode list testing/testing.db "SELECT id FROM users ORDER BY zipcode" > /dev/null
        0.05 real         0.02 user         0.01 sys

Closing

penberg avatar Jun 27 '25 07:06 penberg