Performance tests and analysis of widespread database managment systems through various tests with different number of records. Diagrams of the performance, time and amount of used memory are shown.
- Records: 1,000,000
- Database systems: STSdb, STSdb Compressed, MySQL, Oracle Berkeley DB, SQLite, Perst, Perst Compressed, MS SQL Server Compact 3.5, Db4objects, Access 2007, Firebird
- Tests: Append, Enumerate, Update, Clone, Sort (by double), Sort (by string then by DateTime), Multi-Table Insert, DateTime Insert, DateTime Enumerate Ascending, DateTime Enumerate Descending, Random Insert, Enumerate Fragmented, Random Access, Delete, Summary (Average Speed, Total Time).
- Records: 10,000,000
- Database systems: STSdb, STSdb Compressed, MySQL, SQLite, Perst, Perst Compressed
- Tests: Append, Enumerate, Update, Clone, Sort (by double), Sort (by string then by DateTime), Multi-Table Insert, DateTime Insert, DateTime Enumerate Ascending, DateTime Enumerate Descending, Random Insert, Enumerate Fragmented, Random Access, Delete, Summary (Average Speed, Total Time).
- Records: 100,000,000
- Database systems: STSdb , STSdb Compressed
- Tests: Append, Enumerate, Update, Clone, Sort (by double), Sort (by string then by DateTime), Multi-Table Insert, DateTime Insert, DateTime Enumerate Ascending, DateTime Enumerate Descending, Random Insert, Enumerate Fragmented, Random Access, Delete, Summary (Average Speed, Total Time).
All tests are done with the Database Benchmark performance testing tool. The open-source solution allows you to conduct database workload replay and scalability testing. If you want to test other databases, different numbers of records and configurations, please visit the Benchmark Team.
Sections