> 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](https://github.com/mariadb-corporation/docs-server/blob/test/en/mariadb-5518-release-notes/README.md) + 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" %}


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://mariadb.com/docs/server/reference/product-development/server-development/quality/benchmarks-and-long-running-tests/benchmarks/dbt3-example-preparation-time.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.