This talk is about very heavy database schema / information architecture topics:
- Some anecdotes of slow WordPress / WooCommerce sites, examples to illustrate the need to talk about this
- Rundown on why they were slow
- Detailed explanation of what indexes are, how they work conceptually and what MySQL does if they aren’t available
- Rundown of WordPress / WooCommerce database schema
- Common scenarios of user / client wishes and why the same doesn’t work in a large site (query / order by postmeta values for example)
- What can be done about it (WooCommerce 3.0 data accessor classes, custom database tables, indexing)
- References / links to learn more about this