{"id":1168,"date":"2017-05-22T13:05:49","date_gmt":"2017-05-22T12:05:49","guid":{"rendered":"http:\/\/2017.brighton.wordcamp.org\/?post_type=wcb_session&#038;p=1168"},"modified":"2017-07-11T12:59:36","modified_gmt":"2017-07-11T11:59:36","slug":"things-you-didnt-know-you-need-to-know-about-databases-and-wordpress","status":"publish","type":"wcb_session","link":"https:\/\/brighton.wordcamp.org\/2017\/session\/things-you-didnt-know-you-need-to-know-about-databases-and-wordpress\/","title":{"rendered":"Things you didn&#8217;t know you need to know about databases and WordPress"},"content":{"rendered":"<p>This talk is about very heavy database schema \/ information architecture topics:<\/p>\n<ul>\n<li>Some anecdotes of slow WordPress \/ WooCommerce sites, examples to illustrate the need to talk about this<\/li>\n<li>Rundown on why they were slow<\/li>\n<li>Detailed explanation of what indexes are, how they work conceptually and what MySQL does if they aren\u2019t available<\/li>\n<li>Rundown of WordPress \/ WooCommerce database schema<\/li>\n<li>Common scenarios of user \/ client wishes and why the same doesn&#8217;t work in a large site (query \/ order by postmeta values for example)<\/li>\n<li>What can be done about it (WooCommerce 3.0 data accessor classes, custom database tables, indexing)<\/li>\n<li>References \/ links to learn more about this<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>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\u2019t available Rundown of &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/brighton.wordcamp.org\/2017\/session\/things-you-didnt-know-you-need-to-know-about-databases-and-wordpress\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Things you didn&#8217;t know you need to know about databases and WordPress&#8221;<\/span><\/a><\/p>\n","protected":false},"author":14832409,"featured_media":0,"template":"","meta":{"_crdt_document":"","_wcpt_session_time":1503046800,"_wcpt_session_duration":3000,"_wcpt_session_type":"session","_wcpt_session_slides":"","_wcpt_session_video":"","_wcpt_speaker_id":[1099],"footnotes":""},"session_track":[],"session_category":[],"class_list":["post-1168","wcb_session","type-wcb_session","status-publish","hentry"],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/phePWh-iQ","jetpack_likes_enabled":false,"session_date_time":{"date":"August 18, 2017","time":"10:00 am"},"session_speakers":[{"id":"1099","slug":"gabor-javorszky","name":"Gabor Javorszky","link":"https:\/\/brighton.wordcamp.org\/2017\/speaker\/gabor-javorszky\/"}],"session_cats_rendered":null,"_links":{"self":[{"href":"https:\/\/brighton.wordcamp.org\/2017\/wp-json\/wp\/v2\/sessions\/1168","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/brighton.wordcamp.org\/2017\/wp-json\/wp\/v2\/sessions"}],"about":[{"href":"https:\/\/brighton.wordcamp.org\/2017\/wp-json\/wp\/v2\/types\/wcb_session"}],"author":[{"embeddable":true,"href":"https:\/\/brighton.wordcamp.org\/2017\/wp-json\/wp\/v2\/users\/14832409"}],"version-history":[{"count":3,"href":"https:\/\/brighton.wordcamp.org\/2017\/wp-json\/wp\/v2\/sessions\/1168\/revisions"}],"predecessor-version":[{"id":1240,"href":"https:\/\/brighton.wordcamp.org\/2017\/wp-json\/wp\/v2\/sessions\/1168\/revisions\/1240"}],"speakers":[{"embeddable":true,"href":"https:\/\/brighton.wordcamp.org\/2017\/wp-json\/wp\/v2\/speakers\/1099"}],"wp:attachment":[{"href":"https:\/\/brighton.wordcamp.org\/2017\/wp-json\/wp\/v2\/media?parent=1168"}],"wp:term":[{"taxonomy":"wcb_track","embeddable":true,"href":"https:\/\/brighton.wordcamp.org\/2017\/wp-json\/wp\/v2\/session_track?post=1168"},{"taxonomy":"wcb_session_category","embeddable":true,"href":"https:\/\/brighton.wordcamp.org\/2017\/wp-json\/wp\/v2\/session_category?post=1168"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}