Time to delete 10,000 rows, as well as the size of the respective transactionģ - I'm inserting a string 1,000,000 characters long, in the wide column of each.Time to delete 5,000 rows, as well as the size of the respective transaction.Time to delete 4,000 rows, as well as the size of the respective transaction.Time to delete 3,000 rows, as well as the size of the respective transaction.Time to delete 2,000 rows, as well as the size of the respective transaction.Time to delete 1,000 rows, as well as the size of the respective transaction.Of them, to keep things as similar as possible.Ģ - A round of 10,000 records is inserted and the following rounds of deletes I tried to choose one for each that allows me to store the exact same data in each The data type of the wide column is not exactly the same across all RDBMSs, but The syntax for the auto increment id varies within each RDBMS, but it is just **id INT NOT NULL PRIMARY KEY AUTOINCREMENT, The wide column, with a structure similar to this: The scenario for the test goes like this:ġ - A simple test database is created in each DB instance and a table containing I used the latest available version of each product to keep things as fair as Information related to the RDBMSs and their respective runs Tuning, or specific parameter settings to possibly help improve performance. RDBMS setup is that I tested them right out of the box, without any best practices, That has the exact same specs for the data type of the wide column, I tried toĬhoose something as homologous as possible between them. Things as fair as possible, I'm performing each test in a Linux virtual machine The tests against a SQL Server, MySQL and PostgreSQL database instance. Initial considerationsĪs you probably already have guessed by the title of this article, I'm performing The tests will be done against a set ofġ0,000 records in a table that only has an id column and a wide string (1,000,000Ĭharacters to be precise). Records deletions within each respective RDBMS. In this tip I will be presenting the results I compiled after performing
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |