> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/product-development/server-development/quality/benchmarks-and-long-running-tests/benchmarks/dbt3-example-preparation-time.md).

# DBT3 Example Preparation Time

This page contains database preparation and creation times that were discovered\
while working on the [DBT3 Automation Scripts](/docs/server/reference/product-development/server-development/quality/benchmarks-and-long-running-tests/benchmarks/dbt3-automation-scripts.md).

## 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](/docs/release-notes/community-server/old-releases/5.3/5.3.2.md) + 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.  |                                   |

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}