{"id":6200,"date":"2013-11-18T21:12:02","date_gmt":"2013-11-18T21:12:02","guid":{"rendered":"https:\/\/www.jose-aguilar.com\/blog\/?p=6200"},"modified":"2016-05-19T14:07:57","modified_gmt":"2016-05-19T14:07:57","slug":"como-optimizar-la-base-de-datos-de-prestashop","status":"publish","type":"post","link":"https:\/\/www.jose-aguilar.com\/blog\/como-optimizar-la-base-de-datos-de-prestashop\/","title":{"rendered":"Como optimizar la base de datos de Prestashop"},"content":{"rendered":"<p>A medida que pasan los a\u00f1os, las bases de datos se van llenando de informaci\u00f3n importante y de informaci\u00f3n no tan importante que posiblemente ni siquiera sabes que existe y no te interesa para nada.<\/p>\n<p>Si no est\u00e1s familiarizado con las estad\u00edsticas de presashop y adem\u00e1s no te interesan, puedes dejar mucho m\u00e1s ligera tu base de datos vaciando el contenido de las siguientes tablas:<\/p>\n<ul>\n<li>ps_guest<\/li>\n<li>ps_connections<\/li>\n<li>ps_connections_page<\/li>\n<li>ps_connections_source<\/li>\n<li>ps_page_viewed<\/li>\n<\/ul>\n<p>Ejecutando las siguientes sentencias directamente en la base de datos:<\/p>\n<pre>truncate table ps_page_viewed;\r\ntruncate table ps_connections_page;\r\ntruncate table ps_connections_source;\r\ntruncate table ps_connections;\r\ntruncate table ps_guest;<\/pre>\n<p>Imagina que tu base de datos ahora mismo pesa 300MB, cuando la podemos dejar en tan solo 30MB vaciando las tablas indicadas que en nada afectan al proceso habitual de una tienda online.<\/p>\n<p>En la velocidad de carga no afecta pero hay servidores que te penalizan por llenar tu espacio de base de datos ralentizando la velocidad de carga. Dependiendo de donde est\u00e9s alojado deber\u00e1s tenerlo en cuenta o no.<\/p>\n<p>Otro motivo para optimizarla es que bases de datos tan pesados son muy dif\u00edciles de exportar e importar.<\/p>\n<p>Si no te atreves a hacer esta operaci\u00f3n yo mismo te puedo optimizar tu base de datos dej\u00e1ndola m\u00e1s ligera. No dudes en optimizar. No me hago responsable de la ejecuci\u00f3n indevida de las sentencias indicadas en este tutorial.<\/p>\n<p><a href=\"https:\/\/www.jose-aguilar.com\/blog\/contacto\/\">Solicita optimizaci\u00f3n<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>A medida que pasan los a\u00f1os, las bases de datos se van llenando de informaci\u00f3n importante y de informaci\u00f3n no tan importante que posiblemente ni siquiera sabes que existe y no te interesa para nada. Si no est\u00e1s familiarizado con las estad\u00edsticas de presashop y adem\u00e1s no te interesan, puedes dejar mucho m\u00e1s ligera tu [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":4997,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[],"class_list":["post-6200","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-prestashop"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Como optimizar la base de datos de Prestashop - Jose Aguilar Blog<\/title>\n<meta name=\"description\" content=\"Optimiza r\u00e1pidamente la base de datos de prestashop vaciando las tablas de estad\u00edsticas.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como optimizar la base de datos de Prestashop - Jose Aguilar Blog\" \/>\n<meta property=\"og:description\" content=\"Optimiza r\u00e1pidamente la base de datos de prestashop vaciando las tablas de estad\u00edsticas.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.jose-aguilar.com\/blog\/como-optimizar-la-base-de-datos-de-prestashop\/\" \/>\n<meta property=\"og:site_name\" content=\"Jose Aguilar Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/joseaguilarblog\" \/>\n<meta property=\"article:published_time\" content=\"2013-11-18T21:12:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-05-19T14:07:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/10\/prestashop.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"250\" \/>\n\t<meta property=\"og:image:height\" content=\"250\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Jose Aguilar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@JoseAguilarBlog\" \/>\n<meta name=\"twitter:site\" content=\"@JoseAguilarBlog\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jose Aguilar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/como-optimizar-la-base-de-datos-de-prestashop\/\",\"url\":\"https:\/\/www.jose-aguilar.com\/blog\/como-optimizar-la-base-de-datos-de-prestashop\/\",\"name\":\"Como optimizar la base de datos de Prestashop - Jose Aguilar Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/como-optimizar-la-base-de-datos-de-prestashop\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/como-optimizar-la-base-de-datos-de-prestashop\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/10\/prestashop.jpg\",\"datePublished\":\"2013-11-18T21:12:02+00:00\",\"dateModified\":\"2016-05-19T14:07:57+00:00\",\"author\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/e6d485db1e1140866e95971d17105d11\"},\"description\":\"Optimiza r\u00e1pidamente la base de datos de prestashop vaciando las tablas de estad\u00edsticas.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/como-optimizar-la-base-de-datos-de-prestashop\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.jose-aguilar.com\/blog\/como-optimizar-la-base-de-datos-de-prestashop\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/como-optimizar-la-base-de-datos-de-prestashop\/#primaryimage\",\"url\":\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/10\/prestashop.jpg\",\"contentUrl\":\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/10\/prestashop.jpg\",\"width\":250,\"height\":250},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/como-optimizar-la-base-de-datos-de-prestashop\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/www.jose-aguilar.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como optimizar la base de datos de Prestashop\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#website\",\"url\":\"https:\/\/www.jose-aguilar.com\/blog\/\",\"name\":\"Jose Aguilar Blog\",\"description\":\"Desarrollo Web con PrestaShop, WordPress, PHP, jQuery y Ajax\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.jose-aguilar.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/e6d485db1e1140866e95971d17105d11\",\"name\":\"Jose Aguilar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/abbfef5f1d75260c549d0f2c2842bb697ba1aadff3b2836b39d2590c8a625415?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/abbfef5f1d75260c549d0f2c2842bb697ba1aadff3b2836b39d2590c8a625415?s=96&d=mm&r=g\",\"caption\":\"Jose Aguilar\"},\"description\":\"Director ejecutivo y tecnol\u00f3gico en JA Modules. Experto programador PrestaShop y Experto programador WordPress.\",\"sameAs\":[\"https:\/\/plus.google.com\/114357189801512615537\"],\"url\":\"https:\/\/www.jose-aguilar.com\/blog\/author\/josea902\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Como optimizar la base de datos de Prestashop - Jose Aguilar Blog","description":"Optimiza r\u00e1pidamente la base de datos de prestashop vaciando las tablas de estad\u00edsticas.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"es_ES","og_type":"article","og_title":"Como optimizar la base de datos de Prestashop - Jose Aguilar Blog","og_description":"Optimiza r\u00e1pidamente la base de datos de prestashop vaciando las tablas de estad\u00edsticas.","og_url":"https:\/\/www.jose-aguilar.com\/blog\/como-optimizar-la-base-de-datos-de-prestashop\/","og_site_name":"Jose Aguilar Blog","article_publisher":"https:\/\/www.facebook.com\/joseaguilarblog","article_published_time":"2013-11-18T21:12:02+00:00","article_modified_time":"2016-05-19T14:07:57+00:00","og_image":[{"width":250,"height":250,"url":"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/10\/prestashop.jpg","type":"image\/jpeg"}],"author":"Jose Aguilar","twitter_card":"summary_large_image","twitter_creator":"@JoseAguilarBlog","twitter_site":"@JoseAguilarBlog","twitter_misc":{"Escrito por":"Jose Aguilar","Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.jose-aguilar.com\/blog\/como-optimizar-la-base-de-datos-de-prestashop\/","url":"https:\/\/www.jose-aguilar.com\/blog\/como-optimizar-la-base-de-datos-de-prestashop\/","name":"Como optimizar la base de datos de Prestashop - Jose Aguilar Blog","isPartOf":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/como-optimizar-la-base-de-datos-de-prestashop\/#primaryimage"},"image":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/como-optimizar-la-base-de-datos-de-prestashop\/#primaryimage"},"thumbnailUrl":"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/10\/prestashop.jpg","datePublished":"2013-11-18T21:12:02+00:00","dateModified":"2016-05-19T14:07:57+00:00","author":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/e6d485db1e1140866e95971d17105d11"},"description":"Optimiza r\u00e1pidamente la base de datos de prestashop vaciando las tablas de estad\u00edsticas.","breadcrumb":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/como-optimizar-la-base-de-datos-de-prestashop\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.jose-aguilar.com\/blog\/como-optimizar-la-base-de-datos-de-prestashop\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.jose-aguilar.com\/blog\/como-optimizar-la-base-de-datos-de-prestashop\/#primaryimage","url":"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/10\/prestashop.jpg","contentUrl":"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/10\/prestashop.jpg","width":250,"height":250},{"@type":"BreadcrumbList","@id":"https:\/\/www.jose-aguilar.com\/blog\/como-optimizar-la-base-de-datos-de-prestashop\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/www.jose-aguilar.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Como optimizar la base de datos de Prestashop"}]},{"@type":"WebSite","@id":"https:\/\/www.jose-aguilar.com\/blog\/#website","url":"https:\/\/www.jose-aguilar.com\/blog\/","name":"Jose Aguilar Blog","description":"Desarrollo Web con PrestaShop, WordPress, PHP, jQuery y Ajax","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.jose-aguilar.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/e6d485db1e1140866e95971d17105d11","name":"Jose Aguilar","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/abbfef5f1d75260c549d0f2c2842bb697ba1aadff3b2836b39d2590c8a625415?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/abbfef5f1d75260c549d0f2c2842bb697ba1aadff3b2836b39d2590c8a625415?s=96&d=mm&r=g","caption":"Jose Aguilar"},"description":"Director ejecutivo y tecnol\u00f3gico en JA Modules. Experto programador PrestaShop y Experto programador WordPress.","sameAs":["https:\/\/plus.google.com\/114357189801512615537"],"url":"https:\/\/www.jose-aguilar.com\/blog\/author\/josea902\/"}]}},"_links":{"self":[{"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/posts\/6200","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/comments?post=6200"}],"version-history":[{"count":0,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/posts\/6200\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/media\/4997"}],"wp:attachment":[{"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/media?parent=6200"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/categories?post=6200"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/tags?post=6200"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}