{"id":2277,"date":"2024-08-29T21:16:48","date_gmt":"2024-08-29T19:16:48","guid":{"rendered":"https:\/\/netherlands.wordcamp.org\/2024\/?post_type=wcb_session&#038;p=2277"},"modified":"2024-11-19T20:46:01","modified_gmt":"2024-11-19T19:46:01","slug":"how-to-speed-up-a-site-with-500000-attachments","status":"publish","type":"wcb_session","link":"https:\/\/netherlands.wordcamp.org\/2024\/session\/how-to-speed-up-a-site-with-500000-attachments\/","title":{"rendered":"How to Speed Up a Site with 500,000 Attachments"},"content":{"rendered":"\n<p>In my first week on the job, I was tasked with speeding up a site that was incredibly slow. And when I say slow, I mean REALLY slow: 40 seconds or longer to save a single post. 20 seconds or more just to get to the post editor.<\/p>\n\n\n\n<p>Spoiler: We got it to work! And this is the story of how we fixed it:<\/p>\n\n\n\n<p>We dug through endless lines of code.<br>We read some fantastic resources on the topic.<br>We spoke to our friends in the community, who are experts in their respective fields.<\/p>\n\n\n\n<p>The technical details of this talk include:<\/p>\n\n\n\n<p>xhprof with a custom addition that I wrote.<br>The filter \u2018posts_clauses\u2019.<br>The function \u2018dbDelta()\u2019.<\/p>\n\n\n\n<p>Join me for a deep dive into the techniques and strategies we used to dramatically improve the site\u2019s performance. You\u2019ll walk away with actionable insights and practical tips to speed up your own site!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In my first week on the job, I was tasked with speeding up a site that was incredibly slow. And when I say slow, I mean REALLY slow: 40 seconds or longer to save a single post. 20 seconds or more just to get to the post editor. Spoiler: We got it to work! And [&hellip;]<\/p>\n","protected":false},"author":8521779,"featured_media":0,"template":"","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_post_was_ever_published":false,"_wcpt_session_time":1732956300,"_wcpt_session_duration":2700,"_wcpt_session_type":"session","_wcpt_session_slides":"","_wcpt_session_video":"","_wcpt_speaker_id":[2275],"footnotes":""},"session_track":[40],"session_category":[42,58],"class_list":["post-2277","wcb_session","type-wcb_session","status-publish","hentry","wcb_track-2-servebolt","wcb_session_category-development","wcb_session_category-english"],"jetpack_sharing_enabled":true,"session_date_time":{"date":"30 november 2024","time":"09:45"},"session_speakers":[{"id":"2275","slug":"christoph-daum","name":"Christoph Daum","link":"https:\/\/netherlands.wordcamp.org\/2024\/speaker\/christoph-daum\/"}],"session_cats_rendered":"Development, English","_links":{"self":[{"href":"https:\/\/netherlands.wordcamp.org\/2024\/wp-json\/wp\/v2\/sessions\/2277","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/netherlands.wordcamp.org\/2024\/wp-json\/wp\/v2\/sessions"}],"about":[{"href":"https:\/\/netherlands.wordcamp.org\/2024\/wp-json\/wp\/v2\/types\/wcb_session"}],"version-history":[{"count":4,"href":"https:\/\/netherlands.wordcamp.org\/2024\/wp-json\/wp\/v2\/sessions\/2277\/revisions"}],"predecessor-version":[{"id":4150,"href":"https:\/\/netherlands.wordcamp.org\/2024\/wp-json\/wp\/v2\/sessions\/2277\/revisions\/4150"}],"speakers":[{"embeddable":true,"href":"https:\/\/netherlands.wordcamp.org\/2024\/wp-json\/wp\/v2\/speakers\/2275"}],"author":[{"embeddable":true,"href":"https:\/\/netherlands.wordcamp.org\/2024\/wp-json\/wporg\/v1\/users\/apermo"}],"wp:attachment":[{"href":"https:\/\/netherlands.wordcamp.org\/2024\/wp-json\/wp\/v2\/media?parent=2277"}],"wp:term":[{"taxonomy":"wcb_track","embeddable":true,"href":"https:\/\/netherlands.wordcamp.org\/2024\/wp-json\/wp\/v2\/session_track?post=2277"},{"taxonomy":"wcb_session_category","embeddable":true,"href":"https:\/\/netherlands.wordcamp.org\/2024\/wp-json\/wp\/v2\/session_category?post=2277"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}