• Large Databases

    Comparison of the performance and behavior of different database managment systems through various tests with 100,000,000 records. You can see diagrams of performance, speed and amount of used memory.

    Append

    Adds 100,000,000 records to the database. The database must give an opportunity to directly access the added records by their index.

    Enumerate

    Enumerate 100,000,000 records in order that they are added with the Append test

    Update

    Update (modify) 100,000,000 records, added with the Append test. More specific, the update test have to increase the property of the record.

    Clone

    Clone 100,000,000 records, that were added with the Append test, to another table/database/key-value store.

    Sort (by double)

    Sort 100,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 (by string then by DateTime)

    Sort 100,000,000 records by string and Timestamp properties of a record. This method tests the sort capabilities of the database by two keys.

    Multi-Table Insert

    Seqentally add 100,000,000 recods in many tables. This method tests the database capability to work with many tables simultaneously.

    DateTime Insert

    Insert 100,000,000 recods with primary key of DateTime type. This method tests the capability of the database to work with unique keys.

    DateTime Enumerate Ascending

    Enumerate 100,000,000 records added with the DateTimeInsert test in ascending key order.

    DateTime Enumerate Descending

    Enumerate 100,000,000 records added with the DateTimeInsert test in descending key order.

    Random Insert

    Insert 100,000,000 number of records with primary key of Double type. This method tests the capability to insert records on completely random keys.

    Enumerate Fragmented

    Enumerate 100,000,000 records added with the RandomInsert test in ascending key order.

    Random Access

    Random access to part of all records added with Append test. The number of random accessed records is optimized for best results.

    Delete

    Delete 100,000,000 records added with the Append test. It is implement sequental delete of records - delete record 1, record 2..

    Summary (Average Speed, Total Time)

    Summary of average speed, total time and file size in testing databases with 100,000,000 records.
Copyright © 2011 STSdb. All rights reserved.
STSdb is a product of STS Soft SC. Powered by vBulletin™ Version 4.0.0, Copyright © 2011 vBulletin Solutions, Inc.