{"id":1933,"date":"2018-10-08T15:44:19","date_gmt":"2018-10-08T19:44:19","guid":{"rendered":"https:\/\/2018.portlandme.wordcamp.org\/?post_type=wcb_session&#038;p=1933"},"modified":"2018-10-25T08:01:55","modified_gmt":"2018-10-25T12:01:55","slug":"high-performance-database-queries-in-wordpress","status":"publish","type":"wcb_session","link":"https:\/\/portlandme.wordcamp.org\/2018\/session\/high-performance-database-queries-in-wordpress\/","title":{"rendered":"High-Performance Database Queries in WordPress"},"content":{"rendered":"<p>What makes a database query fast or slow? Are WP_Query&#8217;s taxonomy queries fast? What about meta queries? In this talk, we&#8217;ll dig into the WordPress database schema, talk about what factors influence query performance, and learn how to sniff out potential performance problems before they ever give you a headache. Next, we&#8217;ll discuss strategies for refactoring queries to be as performant as possible, caching strategies, and more.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>What makes a database query fast or slow? Are WP_Query&#8217;s taxonomy queries fast? What about meta queries? In this talk, we&#8217;ll dig into the WordPress database schema, talk about what factors influence query performance, and learn how to sniff out potential performance problems before they ever give you a headache. Next, we&#8217;ll discuss strategies for [&hellip;]<\/p>\n","protected":false},"author":6535998,"featured_media":0,"template":"","meta":{"jetpack_post_was_ever_published":false,"_wcpt_session_time":1541252700,"_wcpt_session_duration":3000,"_wcpt_session_type":"session","_wcpt_session_slides":"","_wcpt_session_video":"","_wcpt_speaker_id":[1932],"footnotes":""},"session_track":[161614],"session_category":[144],"class_list":["post-1933","wcb_session","type-wcb_session","status-publish","hentry","wcb_track-room-a","wcb_session_category-development"],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9NyYe-vb","session_date_time":{"date":"November 3, 2018","time":"9:45 am"},"session_speakers":[{"id":"1932","slug":"matthew-boynes","name":"Matthew Boynes","link":"https:\/\/portlandme.wordcamp.org\/2018\/speaker\/matthew-boynes\/"}],"session_cats_rendered":"Development","_links":{"self":[{"href":"https:\/\/portlandme.wordcamp.org\/2018\/wp-json\/wp\/v2\/sessions\/1933","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/portlandme.wordcamp.org\/2018\/wp-json\/wp\/v2\/sessions"}],"about":[{"href":"https:\/\/portlandme.wordcamp.org\/2018\/wp-json\/wp\/v2\/types\/wcb_session"}],"version-history":[{"count":1,"href":"https:\/\/portlandme.wordcamp.org\/2018\/wp-json\/wp\/v2\/sessions\/1933\/revisions"}],"predecessor-version":[{"id":2028,"href":"https:\/\/portlandme.wordcamp.org\/2018\/wp-json\/wp\/v2\/sessions\/1933\/revisions\/2028"}],"speakers":[{"embeddable":true,"href":"https:\/\/portlandme.wordcamp.org\/2018\/wp-json\/wp\/v2\/speakers\/1932"}],"author":[{"embeddable":true,"href":"https:\/\/portlandme.wordcamp.org\/2018\/wp-json\/wporg\/v1\/users\/mboynes"}],"wp:attachment":[{"href":"https:\/\/portlandme.wordcamp.org\/2018\/wp-json\/wp\/v2\/media?parent=1933"}],"wp:term":[{"taxonomy":"wcb_track","embeddable":true,"href":"https:\/\/portlandme.wordcamp.org\/2018\/wp-json\/wp\/v2\/session_track?post=1933"},{"taxonomy":"wcb_session_category","embeddable":true,"href":"https:\/\/portlandme.wordcamp.org\/2018\/wp-json\/wp\/v2\/session_category?post=1933"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}