DBT3 Example Preparation Time
This page contains database preparation and creation times that were discovered while working on the DBT3 Automation Scripts.
Database creation times
| Setup | Time | Size on Disk |
|---|---|---|
| Postgre s30 on pitbull | 758 min = 12 h 38 min. | 75 GB |
| MariaDB + MyISAM s10 on 4CPU 4GB RAM developer machine | 96 m 22s = 1h 36m 22s | 17 GB |
| MariaDB + MyISAM s100 on facebook-maria2: | 424m 4s = 7h 4m 4s. | 162 GB |
| MariaDB + InnoDB s100 on facebook-maria2: | 577m 42s = 9h 37m 42s. | |
| MariaDB 5.3.2 + InnoDB s30 on facebook-maria1 | 122m39.753s = 2h 2m 40s. | 71 GB |
| MariaDB 5.5.18 + InnoDB s30 on facebook-maria1 | 150m46.218s = 2h 30m 46s. | 71 GB |
| MySQL 5.6.4 + InnoDB s30 on facebook-maria1: | 140m18.272s = 2h 20m 18s. | 71 GB |
| MariaDB + MyISAM s30 on pitbull with pre_create_PK | > 3h 30m (with limited RAM to 11 GB) | |
| MariaDB + MyISAM s30 on facebook-maria1: | 99m 8s = 1h 39m 8s. | 49 GB |
| MySQL 5.6.4 + MyISAM s30 on facebook-maria1 | 114m 17s. | 49 GB |
Dataload creation time
| Setup | Time | Size on Disk |
|---|---|---|
| Scale 10 on 4CPU 4GB RAM developer machine | 8 min 44 sec. | 10.4 GB |
| Scale 30 on pitbull.askmonty.org | 20 min 28 sec. | 32 GB (with limited RAM to 11 GB) |
| Scale 100 on facebook-maria2 | 78 min 27.601s. | 106 GB |
| Scale 30 on facebook-maria1 | 23 min 40 sec. |
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
