Testing Your Queries and Performance
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
Running Queries
Hopefully at this point you have your data in SingleStore.
See why here.
Visual Explain
One great feature of SingleStore is Visual Explain.
Once you identify a bottleneck, you should be able to make changes either to your schema or to your query itself in order to improve speed.
You can manually (non-visually) run EXPLAIN
or PROFILE
from any client; see the links above for details on the commands.
Benchmarking
If you’re moving over from any of the databases we’ve talked about so far, you are probably interested in improving performance.
Once you’ve installed the packages to your host machine, you can walk through this tutorial.svc-xxx-dml.
).3306
, as listed.
Last modified: August 1, 2023