{"id":2219,"date":"2023-07-05T07:48:01","date_gmt":"2023-07-05T05:48:01","guid":{"rendered":"https:\/\/biarritz.wordcamp.org\/2023\/?post_type=wcb_session&#038;p=2219"},"modified":"2023-08-03T11:45:30","modified_gmt":"2023-08-03T09:45:30","slug":"comprendre-et-optimiser-notre-base-de-donnees-wordpress","status":"publish","type":"wcb_session","link":"https:\/\/biarritz.wordcamp.org\/2023\/session\/comprendre-et-optimiser-notre-base-de-donnees-wordpress\/","title":{"rendered":"Comprendre et optimiser notre base de donn\u00e9es WordPress"},"content":{"rendered":"\n<p>La base de donn\u00e9es est le c\u0153ur battant de tout site WordPress, contenant toutes les informations cruciales n\u00e9cessaires pour son fonctionnement. A l&rsquo;heure o\u00f9 nous utilisons WordPress dans des environnements de plus en plus complexes et o\u00f9 des plugins cr\u00e9ent leurs tables custom pour optimiser la gestion de leur donn\u00e9es, il est important de comprendre l&rsquo;enjeu de la couche de donn\u00e9es. Sans une gestion et une optimisation appropri\u00e9es, la base de donn\u00e9es peut devenir un goulot d&rsquo;\u00e9tranglement affectant les performances globales du site. Comment juger d&rsquo;une bonne structure de donn\u00e9es ? Est-ce qu&rsquo;une table custom est-elle bien con\u00e7ue et ne d\u00e9grade-t-elle pas mes performances ? Faisons un tour d&rsquo;horizon de ce qu&rsquo;il en est et sur quoi il faut porter son attention.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>La base de donn\u00e9es est le c\u0153ur battant de tout site WordPress, contenant toutes les informations cruciales n\u00e9cessaires pour son fonctionnement. A l&rsquo;heure o\u00f9 nous utilisons WordPress dans des environnements de plus en plus complexes et o\u00f9 des plugins cr\u00e9ent leurs tables custom pour optimiser la gestion de leur donn\u00e9es, il est important de comprendre [&hellip;]<\/p>\n","protected":false},"author":15697055,"featured_media":2596,"template":"","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_post_was_ever_published":false,"_wcpt_session_time":1696599000,"_wcpt_session_duration":1800,"_wcpt_session_type":"session","_wcpt_session_slides":"","_wcpt_session_video":"","_wcpt_speaker_id":[2217],"footnotes":""},"session_track":[26],"session_category":[],"class_list":["post-2219","wcb_session","type-wcb_session","status-publish","has-post-thumbnail","hentry","wcb_track-1-amphitheatre"],"jetpack_sharing_enabled":true,"session_date_time":{"date":"6 octobre 2023","time":"15h30"},"session_speakers":[{"id":"2217","slug":"thomas-deneulin","name":"Thomas Deneulin","link":"https:\/\/biarritz.wordcamp.org\/2023\/speaker\/thomas-deneulin\/"}],"session_cats_rendered":null,"_links":{"self":[{"href":"https:\/\/biarritz.wordcamp.org\/2023\/wp-json\/wp\/v2\/sessions\/2219","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/biarritz.wordcamp.org\/2023\/wp-json\/wp\/v2\/sessions"}],"about":[{"href":"https:\/\/biarritz.wordcamp.org\/2023\/wp-json\/wp\/v2\/types\/wcb_session"}],"author":[{"embeddable":true,"href":"https:\/\/biarritz.wordcamp.org\/2023\/wp-json\/wp\/v2\/users\/15697055"}],"version-history":[{"count":2,"href":"https:\/\/biarritz.wordcamp.org\/2023\/wp-json\/wp\/v2\/sessions\/2219\/revisions"}],"predecessor-version":[{"id":2266,"href":"https:\/\/biarritz.wordcamp.org\/2023\/wp-json\/wp\/v2\/sessions\/2219\/revisions\/2266"}],"speakers":[{"embeddable":true,"href":"https:\/\/biarritz.wordcamp.org\/2023\/wp-json\/wp\/v2\/speakers\/2217"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/biarritz.wordcamp.org\/2023\/wp-json\/wp\/v2\/media\/2596"}],"wp:attachment":[{"href":"https:\/\/biarritz.wordcamp.org\/2023\/wp-json\/wp\/v2\/media?parent=2219"}],"wp:term":[{"taxonomy":"wcb_track","embeddable":true,"href":"https:\/\/biarritz.wordcamp.org\/2023\/wp-json\/wp\/v2\/session_track?post=2219"},{"taxonomy":"wcb_session_category","embeddable":true,"href":"https:\/\/biarritz.wordcamp.org\/2023\/wp-json\/wp\/v2\/session_category?post=2219"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}