At present, successive updates to PyrrhoDB v7 alpha are on GitHub . As of today, this location contains the 14 September 2019 version, and a version of TpccPyrrho. The TPC-C benchmark test is for OLTP for a warehouse, where the clerk works through a task sequence including new orders, with realistic time delays. In 10 minutes the clerk handles 16 new orders along with other tasks.
In order to demonstrate exceptional handling of concurrency, this version of the benchmark uses multiple clerks per warehouse. This introduces high levels of concurrency and many transactions should fail. With StrongDBMS I demonstrated performance superior to commercial databases, and now can do the same with the alpha version of PyrrhoDB. The GitHub repository includes versions of the benchmark for several popular DBMS so this claim can be verified by anyone interested.
The results for Pyrrho v7 alpha are as follows:
Recreate DB: 1:02
Fill stock: 2:02
Fill districts: 6:15
Cold start with initial warehouse: 1:30
F:\PyrrhoDB7\Pyrrho>tpccpyrrho
fid 1 loaded at
15/09/2019 12:04:32
Started at
15/09/2019 12:04:40 with 1 clerks
fid 2 loaded at 15/09/2019
12:04:40
At 15/09/2019
12:14:40 Commits 16, Conflicts 0 0
Last fid=2
F:\PyrrhoDB7\Pyrrho>tpccpyrrho
fid 1 loaded at
15/09/2019 12:17:56
Started at
15/09/2019 12:18:03 with 10 clerks
fid 11 loaded at
15/09/2019 12:18:03
At 15/09/2019
12:28:03 Commits 145, Conflicts 0 95
Last fid=11
F:\PyrrhoDB7\Pyrrho>tpccpyrrho
fid 1 loaded at
15/09/2019 12:32:41
Started at
15/09/2019 12:33:33 with 100 clerks
fid 101 loaded at
15/09/2019 12:35:01
At 15/09/2019
12:43:33 Commits 313, Conflicts 0 2920
Last fid=101
F:\PyrrhoDB7\Pyrrho>
During the
benchmark test for 100 clerks my desktop machine reported the CPU utilisation
was around 40% and the memory utilisation 50%.
PyrrhoDB v7 should reach beta version by December and include all of the usual database features as in previous versions of the DBMS.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment