Comparison of the performance and behavior of different database managment systems through various tests with 1,000,000 records. You can see diagrams of performance, speed and amount of used memory.
Adds 1,000,000 records to the database. The database must give an opportunity to directly access the added records by their index.
Enumerate 1,000,000 records in order that they are added with the Append test
Update (modify) 1,000,000 records, added with the Append test. More specific, the update test have to increase the property of the record.
Clone 1,000,000 records, that were added with the Append test, to another table/database/key-value store.
Sort 1,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 1,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 1,000,000 recods in many tables. This method tests the database capability to work with many tables simultaneously.
Insert 1,000,000 recods with primary key of DateTime type. This method tests the capability of the database to work with unique keys.
Enumerate 1,000,000 records added with the DateTimeInsert test in ascending key order.
Enumerate 1,000,000 records added with the DateTimeInsert test in descending key order.
Insert 1,000,000 number of records with primary key of Double type. This method tests the capability to insert records on completely random keys.
Enumerate 1,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 1,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 1,000,000 records.
Sections