Just gave SurrealDB 1.0.0, one of the new Rust kids on the block, a try. Goal: compare performance to PostgreSQL.
Both databases were setup on the same machine (x86_64, 8 cores).
Data: a table with 50.000 small rows (~60bytes). One column is a INT value between NULL and 250.
The raw file size on both databases was below 9 MBs.
Query in Postgres:
select count(*) from objects where score > 100;
Query in SurrealDB:
select count() from objects
where score > 100
group all
The count result will be 22.000.
Here are the results after a few repeated executions:
No index:
Postgres: 28ms
SurrealDB: 801ms
With index:
Postgres: 12ms
SurrealDB: 620ms
Time for creating the index:
Postgres: 50ms
SurrealDB: 8.140ms
I’m kind of disappointed about the result, given the small table size. I can’t see how SurrealDB would scale with bigger setups and wonder about the hype around it.
#surrealdb #postgresql #benchmark