Speakers: Gabor Javorszky

  • Gabor Javorszky: Things You Didn’t Know You Need to Know About Databases and WordPress

    WordCamp Brighton 2017Speaker: Gabor Javorszky

    February 8, 2018 — 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