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