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
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
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.

_{This page is licensed: CC BY-SA / Gnu FDL}