SonicBase. In-memory embedded or distributed streaming sql database
SonicBase includes a benchmark framework which allows you to analyze the performance of the database. To run
the benchmark framework you must configure client machines to do the work. The following is an example of a configuration
that includes clients. Usually you need as many or more clients than servers.
To start the benchmark clients type "bench start cluster". To stop the benchmark clients type "bench stop cluster".
You must load the schema that is used for the benchmarks. Type "run script init-tables.command". This will load
To do a batch insert test, type "bench start insert 0", where 0 is the start offset of the ids to insert in the
database. To monitor progress of the inserts type "bench stats insert". To stop the inserts type "bench stop "cluster".
When doig a insert benchmark you must be careful to stop the test before you run out of memory.
Batch Identity Lookup
To do a batch identity lookup test, type "bench start identity batch". This does a lookup with the "in expression".
To monitor progress of the lookups
type "bench stats identity". To stop the lookups type "bench stop cluster".
You may also do a batch lookup with composite keys. The command for this is "bench start identity cbatch".
To do a range lookup test, type "bench start range". To monitor progress of the lookups type
"bench stats range". To stop the lookups type "bench stop cluster".
Note that if you stop a test with "bench stop cluster" you will need to type "bench start cluster" before running
the next test.