{"id":6101,"date":"2026-09-21T19:25:45","date_gmt":"2026-09-21T17:25:45","guid":{"rendered":"https:\/\/wroclaw.wordcamp.org\/2026\/?post_type=wcb_session&#038;p=6101"},"modified":"2026-09-21T19:25:45","modified_gmt":"2026-09-21T17:25:45","slug":"wordpress-at-tens-of-millions-of-requests-postmeta-indexes-and-other-bottlenecks","status":"publish","type":"wcb_session","link":"https:\/\/wroclaw.wordcamp.org\/2026\/session\/wordpress-at-tens-of-millions-of-requests-postmeta-indexes-and-other-bottlenecks\/","title":{"rendered":"WordPress at Tens of Millions of Requests: postmeta, indexes and other bottlenecks"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">WordPress has a reputation for being slow at scale. It isn&#8217;t \u2014 but its database layer punishes you for ignoring it. In this talk I&#8217;ll walk through real bottlenecks from an enterprise media platform serving tens of millions of HTTP requests a month: why wp_postmeta becomes the number one suspect, how EAV design turns innocent meta_query calls into multi-second JOINs, and how to diagnose this with EXPLAIN and Query Monitor before your client notices. You&#8217;ll get a practical ladder of fixes \u2014 from indexes and query rewrites that work on any shared hosting, to custom tables and object caching for high-traffic projects \u2014 each with before\/after numbers. No theory you can&#8217;t apply on Monday.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>WordPress has a reputation for being slow at scale. It isn&#8217;t \u2014 but its database layer punishes you for ignoring it. In this talk I&#8217;ll walk through real bottlenecks from an enterprise media platform serving tens of millions of HTTP requests a month: why wp_postmeta becomes the number one suspect, how EAV design turns innocent [&hellip;]<\/p>\n","protected":false},"author":15890890,"featured_media":0,"template":"","meta":{"_wcpt_session_time":1791032400,"_wcpt_session_duration":1800,"_wcpt_session_type":"session","_wcpt_session_slides":"","_wcpt_session_video":"","_wcpt_speaker_id":[5904],"footnotes":""},"session_track":[22],"session_category":[39],"class_list":["post-6101","wcb_session","type-wcb_session","status-publish","hentry","wcb_track-track-1","wcb_session_category-english-track"],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/phe2Xs-1Ap","session_date_time":{"date":"3 pa\u017adziernika, 2026","time":"15:00"},"session_speakers":[{"id":"5904","slug":"serhii-pylypenko","name":"Serhii Pylypenko","link":"https:\/\/wroclaw.wordcamp.org\/2026\/speaker\/serhii-pylypenko\/"}],"session_cats_rendered":"English track","_links":{"self":[{"href":"https:\/\/wroclaw.wordcamp.org\/2026\/wp-json\/wp\/v2\/sessions\/6101","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wroclaw.wordcamp.org\/2026\/wp-json\/wp\/v2\/sessions"}],"about":[{"href":"https:\/\/wroclaw.wordcamp.org\/2026\/wp-json\/wp\/v2\/types\/wcb_session"}],"author":[{"embeddable":true,"href":"https:\/\/wroclaw.wordcamp.org\/2026\/wp-json\/wp\/v2\/users\/15890890"}],"version-history":[{"count":1,"href":"https:\/\/wroclaw.wordcamp.org\/2026\/wp-json\/wp\/v2\/sessions\/6101\/revisions"}],"predecessor-version":[{"id":6102,"href":"https:\/\/wroclaw.wordcamp.org\/2026\/wp-json\/wp\/v2\/sessions\/6101\/revisions\/6102"}],"speakers":[{"embeddable":true,"href":"https:\/\/wroclaw.wordcamp.org\/2026\/wp-json\/wp\/v2\/speakers\/5904"}],"wp:attachment":[{"href":"https:\/\/wroclaw.wordcamp.org\/2026\/wp-json\/wp\/v2\/media?parent=6101"}],"wp:term":[{"taxonomy":"wcb_track","embeddable":true,"href":"https:\/\/wroclaw.wordcamp.org\/2026\/wp-json\/wp\/v2\/session_track?post=6101"},{"taxonomy":"wcb_session_category","embeddable":true,"href":"https:\/\/wroclaw.wordcamp.org\/2026\/wp-json\/wp\/v2\/session_category?post=6101"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}