turso
turso copied to clipboard
`ORDER BY` is much slower compared to SQLite
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
Likely https://github.com/penberg/limbo/issues/203
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