Speed of the ScimoreDB Engine
As part of our last large scale out test of ScimoreDB engine, we implemented the TPC-C test. It defines data structures and the test queries reflecting a standard application - the IT system of a warehouse company. It includes purchasing process, cancelling orders, inventory control, logging of actions. Each transaction included many inserts, updates and selects.
Setup
The machines in the test where 2.13 Ghz Duo Core, 2Gb memory, single sata disc standard Dell office machines
Database configuration: 150.000 pages of memory pr. machines, corresponding to 1.14GB memory.
Database size: Approx. 500Mb data. During the test, the size of the database increases.
Results
From ScimoreDB average performance where:
| inserts/s | 3000 |
| updates/s | 3000 |
| selects/s | 2500 |
| total queries/s | 8500 |
| tpc-c trans/s | 530 |
The number where achieved by optimizing indexes, and using stored procedures.
Note that this is with full ACID transactional enabled. Larger
number is achievable using in memory transactions. Also note the above test was
not validated as required by tpc organisation.
Read the full results from the TPC-C test here.