hello, are there any benchmarks comparing SingleSt...
# questions-and-troubleshooting
t
hello, are there any benchmarks comparing SingleStore vs StarRocks? We are currently using SingleStore and i am evaluating StarRocks as an open source alternative.
m
Hey @Tom Kühl sorry for the delay on my part. To my knowledge, there are no published benchmarks directly comparing SingleStore and StarRocks. That said, I've run POCs against SingleStore on two separate occasions and saw better overall query performance with StarRocks in both cases — though I'd strongly encourage you to run your own tests against your actual workload, since results are always data - and query -dependent. A few things worth flagging from those evaluations: Stored procedures — One blocker we hit was heavy reliance on stored procedures. StarRocks doesn't have robust stored procedure support, so if your team leans on them heavily, that's a real migration cost to account for. More broadly, I'm cautious about business logic living inside the database: it competes for the same hardware resources as query execution, and it creates tight vendor lock-in that makes it harder to swap components or add other tools into your data pipeline down the road. OLAP vs. hybrid — This is probably the most important consideration. SingleStore is designed as a hybrid OLTP/OLAP system. StarRocks is purpose-built for OLAP. If you're using SingleStore for transactional workloads alongside analytics, you'll need to evaluate how to handle that OLTP piece separately.