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

Continue the discussion

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Published

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

Rate this:

Event

WordCamp Brighton 2017 15

Speakers

Gabor Javorszky 1

Tags

Databases 3

Language

English 6602

Download
MP4: Low, Med, High
OGG: Low
Subtitles
Subtitle this video →
Producer
%d bloggers like this: