Comparison of the performance and behavior of different database managment systems through various tests with 10,000,000 records. You can see diagrams of performance, speed and amount of used memory.
Adds 10,000,000 records to the database. The database must give an opportunity to directly access the added records by their index.
Enumerate 10,000,000 records in order that they are added with the Append test
Update (modify) 10,000,000 records, added with the Append test. More specific, the update test have to increase the property of the record.
Clone 10,000,000 records, that were added with the Append test, to another table/database/key-value store.
Sort 10,000,000 records added with the Append test by property of a record. Ordered records have to be stored in another table/database/key-value store.
Sort 10,000,000 records by string and Timestamp properties of a record. This method tests the sort capabilities of the database by two keys.
Seqentally add 10,000,000 recods in many tables. This method tests the database capability to work with many tables simultaneously.
Insert 10,000,000 recods with primary key of DateTime type. This method tests the capability of the database to work with unique keys.
Enumerate 10,000,000 records added with the DateTimeInsert test in ascending key order.
Enumerate 10,000,000 records added with the DateTimeInsert test in descending key order.
Insert 10,000,000 number of records with primary key of Double type. This method tests the capability to insert records on completely random keys.
Enumerate 10,000,000 records added with the RandomInsert test in ascending key order.
Random access to part of all records added with Append test. The number of random accessed records is optimized for best results.
Delete 10,000,000 records added with the Append test. It is implement sequental delete of records - delete record 1, record 2..
Summary of average speed, total time and file size in testing databases with 10,000,000 records.
Sections