{"id":1521,"date":"2024-04-12T15:30:55","date_gmt":"2024-04-12T19:30:55","guid":{"rendered":"https:\/\/buffalo.wordcamp.org\/2024\/?post_type=wcb_session&#038;p=1521"},"modified":"2024-04-12T18:05:48","modified_gmt":"2024-04-12T22:05:48","slug":"database-optimization-and-maintenance","status":"publish","type":"wcb_session","link":"https:\/\/buffalo.wordcamp.org\/2024\/session\/database-optimization-and-maintenance\/","title":{"rendered":"Database Optimization and Maintenance"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">The WordPress database is where all your posts, pages, comments, users, and plugin and theme configurations live. It is the lifeblood of your website. However, not many people put much effort into optimizing or maintaining their databases.<\/p>\n\n\n<p class=\"wp-block-paragraph\">In this session, we&#8217;ll explore some of what goes into maintaining a database and what you can do to keep things clean, lean, and fast.<\/p>\n\n\n<div class=\"wp-block-wordcamp-session-speakers\"><span class=\"wp-block-wordcamp-session-speakers__byline\">Presented by<\/span><span class=\"wp-block-wordcamp-session-speakers__name\"><a href=\"https:\/\/buffalo.wordcamp.org\/2024\/speaker\/micah-wood\/\">Micah Wood<\/a><\/span><\/div>","protected":false},"excerpt":{"rendered":"<p>The WordPress database is where all your posts, pages, comments, users, and plugin and theme configurations live. It is the lifeblood of your website. However, not many people put much effort into optimizing or maintaining their databases. In this session, we&#8217;ll explore some of what goes into maintaining a database and what you can do [&hellip;]<\/p>\n","protected":false},"author":9114287,"featured_media":0,"template":"","meta":{"_crdt_document":"","jetpack_post_was_ever_published":false,"_wcpt_session_time":1714834800,"_wcpt_session_duration":3600,"_wcpt_session_type":"session","_wcpt_session_slides":"","_wcpt_session_video":"","_wcpt_speaker_id":[1516],"footnotes":""},"session_track":[25],"session_category":[],"class_list":["post-1521","wcb_session","type-wcb_session","status-publish","hentry","wcb_track-track-2-site-builders-developers"],"jetpack_sharing_enabled":true,"session_date_time":{"date":"May 4, 2024","time":"11:00 am"},"session_speakers":[{"id":"1516","slug":"micah-wood","name":"Micah Wood","link":"https:\/\/buffalo.wordcamp.org\/2024\/speaker\/micah-wood\/"}],"session_cats_rendered":null,"_links":{"self":[{"href":"https:\/\/buffalo.wordcamp.org\/2024\/wp-json\/wp\/v2\/sessions\/1521","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buffalo.wordcamp.org\/2024\/wp-json\/wp\/v2\/sessions"}],"about":[{"href":"https:\/\/buffalo.wordcamp.org\/2024\/wp-json\/wp\/v2\/types\/wcb_session"}],"version-history":[{"count":2,"href":"https:\/\/buffalo.wordcamp.org\/2024\/wp-json\/wp\/v2\/sessions\/1521\/revisions"}],"predecessor-version":[{"id":1979,"href":"https:\/\/buffalo.wordcamp.org\/2024\/wp-json\/wp\/v2\/sessions\/1521\/revisions\/1979"}],"speakers":[{"embeddable":true,"href":"https:\/\/buffalo.wordcamp.org\/2024\/wp-json\/wp\/v2\/speakers\/1516"}],"author":[{"embeddable":true,"href":"https:\/\/buffalo.wordcamp.org\/2024\/wp-json\/wporg\/v1\/users\/wpscholar"}],"wp:attachment":[{"href":"https:\/\/buffalo.wordcamp.org\/2024\/wp-json\/wp\/v2\/media?parent=1521"}],"wp:term":[{"taxonomy":"wcb_track","embeddable":true,"href":"https:\/\/buffalo.wordcamp.org\/2024\/wp-json\/wp\/v2\/session_track?post=1521"},{"taxonomy":"wcb_session_category","embeddable":true,"href":"https:\/\/buffalo.wordcamp.org\/2024\/wp-json\/wp\/v2\/session_category?post=1521"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}