{"id":711,"date":"2014-10-04T12:02:34","date_gmt":"2014-10-04T15:02:34","guid":{"rendered":"http:\/\/www.pandemiahosting.com\/hosting.blog\/?p=711"},"modified":"2014-10-04T12:02:34","modified_gmt":"2014-10-04T15:02:34","slug":"optimizar-magento","status":"publish","type":"post","link":"https:\/\/www.pandemiahosting.com\/hosting.blog\/optimizar-magento\/","title":{"rendered":"Optimizar Magento"},"content":{"rendered":"

Magento<\/strong> es una aplicaci\u00f3n de comercio electr\u00f3nico muy popular pero tambi\u00e9n tiene sus desventajas en cuanto a uso de recursos.<\/p>\n

Aqu\u00ed est\u00e1n algunas sugerencias para la optimizaci\u00f3n de una instalaci\u00f3n de Magento.<\/p>\n

Por favor recuerde que Magento es una aplicaci\u00f3n que realiza uso intensivo en recursos de cpu del servidor, y si usted est\u00e1 teniendo problemas con el uso de recursos continuo, ya deber\u00eda considerar la posibilidad de trasladarse a un servidor de hosting vps<\/a> o un servidor dedicado<\/a>\u00a0totalmente administrador por nosotros.<\/p>\n

OPTIMIZAR MAGENTO desde ADMINISTRADOR<\/strong><\/span><\/p>\n

Desinstala todas las extensiones que no utilices actualmente.<\/p>\n

Habilita todos los caches de Magento: entra en tu Administrador de Magento, luego en Sistema > Gestor de la cache (habilitarlo).<\/p>\n

Combina los archivos Javascript y combina los archivos CSS, sigue estos pasos:
\nentra en tu Administrador, luego en Sistema > Configuraci\u00f3n > Avanzado > Desarrollador > \u2018Javascript settings\u2019 y \u2018CSS Settings\u2019.
\nTambi\u00e9n puedes usar una extensi\u00f3n para hacer esto mismo como Fooman Speedster.<\/p>\n

Usa la caracter\u00edstica de Compilaci\u00f3n de Magento, sigue estos pasos:
\ndesde el la seccion Administracion en Sistema > Herramientas > Compilation.<\/p>\n

Desabilita el log de Magento, sigue estos pasos: Sistema > Configuraci\u00f3n > Avanzado > Desarrollador > Log Settings (desactivalo).<\/p>\n

 <\/p>\n

OPTIMIZAR\u00a0MAGENTO modificando archivo htaccess<\/strong><\/span><\/p>\n

Cambios a .htaccess habilitando la compresi\u00f3n de salida<\/p>\n

En su archivo htaccess para Magento que se encuentra una secci\u00f3n de texto que comienza con la frase: <IfModule mod_deflate.c> y termina en <\/ IfModule><\/p>\n

Esta secci\u00f3n del c\u00f3digo se puede utilizar para activar el m\u00f3dulo mod_deflate de Apache, lo que proporciona una compresi\u00f3n de texto, css y javascript.<\/p>\n

Usted tendr\u00e1 que descomentar (quitar el s\u00edmbolo #) varias l\u00edneas para que se vea as\u00ed:<\/p>\n

<IfModule mod_deflate.c><\/p>\n

############################################
\n## enable apache served files compression
\n## http:\/\/developer.yahoo.com\/performance\/rules.html#gzip<\/p>\n

# Insert filter on all content
\nSetOutputFilter DEFLATE
\n# Insert filter on selected content types only
\nAddOutputFilterByType DEFLATE text\/html text\/plain text\/xml
\ntext\/css text\/javascript<\/p>\n

# Netscape 4.x has some problems…
\nBrowserMatch ^Mozilla\/4 gzip-only-text\/html<\/p>\n

# Netscape 4.06-4.08 have some more problems
\nBrowserMatch ^Mozilla\/4\\.0[678] no-gzip<\/p>\n

# MSIE masquerades as Netscape, but it is fine
\nBrowserMatch \\bMSIE !no-gzip !gzip-only-text\/html<\/p>\n

# Don’t compress images
\nSetEnvIfNoCase Request_URI \\.(?:gif|jpe?g|png)$ no-gzip dont-vary<\/p>\n

# Make sure proxies don’t deliver the wrong content
\nHeader append Vary User-Agent env=!dont-vary<\/p>\n

<\/IfModule><\/p>\n

 <\/p>\n

OPTIMIZAR MAGENTO BASES DE DATOS<\/strong><\/span><\/p>\n

Uno de los principales problemas con los sitios de comercio electr\u00f3nico realizados en Magento y que se vuelven lentos, es a causa de tener grandes bases de datos (muchos productos, clientes, registros de actividad, etc), las cuales se vuelven lentas al ser consultadas y al trabajar con ellas.<\/p>\n

Aqu\u00ed hay algunos consejos para reducir el tama\u00f1o de su base de datos de Magento.<\/p>\n

NOTA: Por favor, aseg\u00farese de copia de seguridad de su base de datos antes de realizar cualquiera de los siguientes cambios.<\/em><\/span><\/p>\n

Hay varias tablas utilizadas por Magento para el registro.<\/p>\n

Mientras que el registro es muy importante con respecto a saber lo que tiene y que est\u00e1 pasando con su tienda, los registros se hacen grandes muy r\u00e1pidamente, por lo cual hacer un mantenimiento regular puede ser de gran ayuda.<\/p>\n

Aqu\u00ed est\u00e1n las tablas de registro:<\/p>\n

log_customer
\nlog_visitor
\nlog_visitor_info
\nlog_url
\nlog_url_info
\nlog_quote
\nreport_viewed_product_index
\nreport_compared_product_index
\nreport_event
\ncatalog_compare_item<\/p>\n

LIMPIEZA de BASES DE DATOS mediante Administraci\u00f3n Magento<\/strong><\/span><\/p>\n

En Administraci\u00f3n de Magento vaya a Sistema > Configuraci\u00f3n
\nEn el men\u00fa de la izquierda debajo Avanzado haga clic en Sistema
\nEn \u00abServicio de limpieza de registro\u00bb, cambie \u00abHabilitar Limpieza Log\u00bb a YES y configurar el Guardar registro durante 14 d\u00edas.
\nHaga clic en \u00abGuardar configuraci\u00f3n\u00bb<\/p>\n

LIMPIEZA de BASES DE DATOS MAGENTO a trav\u00e9s de phpMyAdmin<\/strong><\/span><\/p>\n

Usando phpMyAdmin ofrece m\u00e1s flexibilidad y eficiencia al trabajar con bases de datos.<\/p>\n

Inicia sesi\u00f3n para cPanel y haga clic en phpMyAdmin
\nHaga clic en la base de datos asociada con la instalaci\u00f3n de Magento<\/p>\n

Ahora seleccione estas tablas:<\/p>\n

log_customer
\nlog_quote
\nlog_summary
\nlog_summary_type
\nlog_url
\nlog_url_info
\nlog_visitor
\nlog_visitor_info
\nlog_visitor_online<\/p>\n

Debajo de las tablas listadas, haga clic en el cuadro desplegable \u00abCon Seleccionado:\u00bb y seleccione Empty
\nUsted recibir\u00e1 una pantalla de confirmaci\u00f3n, haga clic en S\u00ed.
\nImportante:\u00a0<\/em>Usted tendr\u00e1 que realizar esta tarea de limpieza de base de datos de forma regular.<\/em><\/span><\/p>\n

\"hosting<\/a>
hosting vps magento<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"

Magento es una aplicaci\u00f3n de comercio electr\u00f3nico muy popular pero tambi\u00e9n tiene sus desventajas en cuanto a uso de recursos. Aqu\u00ed est\u00e1n algunas sugerencias para la optimizaci\u00f3n de una instalaci\u00f3n de Magento. Por favor recuerde que Magento es una aplicaci\u00f3n que realiza uso intensivo en recursos de cpu del servidor, y si usted est\u00e1 teniendo […]<\/p>\n","protected":false},"author":2,"featured_media":712,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[67],"tags":[102,105,104],"class_list":["post-711","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-manuales-magento","tag-magento","tag-optimizar-magento","tag-vps-magento"],"yoast_head":"\nOptimizar Magento<\/title>\n<meta name=\"description\" content=\"Optimizar Magento para que cargue mas rapido\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.pandemiahosting.com\/hosting.blog\/optimizar-magento\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Optimizar Magento\" \/>\n<meta property=\"og:description\" content=\"Optimizar Magento para que cargue mas rapido\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pandemiahosting.com\/hosting.blog\/optimizar-magento\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog Pandemia Hosting\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/pandemiahosting\" \/>\n<meta property=\"article:published_time\" content=\"2014-10-04T15:02:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.pandemiahosting.com\/hosting.blog\/wp-content\/uploads\/2014\/10\/magento-optimizacion.png\" \/>\n\t<meta property=\"og:image:width\" content=\"318\" \/>\n\t<meta property=\"og:image:height\" content=\"100\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"pandemia\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@pandemiahosting\" \/>\n<meta name=\"twitter:site\" content=\"@pandemiahosting\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"pandemia\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.pandemiahosting.com\\\/hosting.blog\\\/optimizar-magento\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.pandemiahosting.com\\\/hosting.blog\\\/optimizar-magento\\\/\"},\"author\":{\"name\":\"pandemia\",\"@id\":\"https:\\\/\\\/www.pandemiahosting.com\\\/hosting.blog\\\/#\\\/schema\\\/person\\\/8eeb0eb551a41b1fd6211ee4c7bee5d4\"},\"headline\":\"Optimizar Magento\",\"datePublished\":\"2014-10-04T15:02:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.pandemiahosting.com\\\/hosting.blog\\\/optimizar-magento\\\/\"},\"wordCount\":775,\"image\":{\"@id\":\"https:\\\/\\\/www.pandemiahosting.com\\\/hosting.blog\\\/optimizar-magento\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.pandemiahosting.com\\\/hosting.blog\\\/wp-content\\\/uploads\\\/2014\\\/10\\\/magento-optimizacion.png\",\"keywords\":[\"magento\",\"optimizar magento\",\"vps magento\"],\"articleSection\":[\"Magento\"],\"inLanguage\":\"es\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.pandemiahosting.com\\\/hosting.blog\\\/optimizar-magento\\\/\",\"url\":\"https:\\\/\\\/www.pandemiahosting.com\\\/hosting.blog\\\/optimizar-magento\\\/\",\"name\":\"Optimizar Magento\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.pandemiahosting.com\\\/hosting.blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.pandemiahosting.com\\\/hosting.blog\\\/optimizar-magento\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.pandemiahosting.com\\\/hosting.blog\\\/optimizar-magento\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.pandemiahosting.com\\\/hosting.blog\\\/wp-content\\\/uploads\\\/2014\\\/10\\\/magento-optimizacion.png\",\"datePublished\":\"2014-10-04T15:02:34+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.pandemiahosting.com\\\/hosting.blog\\\/#\\\/schema\\\/person\\\/8eeb0eb551a41b1fd6211ee4c7bee5d4\"},\"description\":\"Optimizar Magento para que cargue mas rapido\",\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.pandemiahosting.com\\\/hosting.blog\\\/optimizar-magento\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/www.pandemiahosting.com\\\/hosting.blog\\\/optimizar-magento\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.pandemiahosting.com\\\/hosting.blog\\\/wp-content\\\/uploads\\\/2014\\\/10\\\/magento-optimizacion.png\",\"contentUrl\":\"https:\\\/\\\/www.pandemiahosting.com\\\/hosting.blog\\\/wp-content\\\/uploads\\\/2014\\\/10\\\/magento-optimizacion.png\",\"width\":318,\"height\":100,\"caption\":\"optimizacion magento\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.pandemiahosting.com\\\/hosting.blog\\\/#website\",\"url\":\"https:\\\/\\\/www.pandemiahosting.com\\\/hosting.blog\\\/\",\"name\":\"Blog Pandemia Hosting\",\"description\":\"Hosting en Uruguay\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.pandemiahosting.com\\\/hosting.blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.pandemiahosting.com\\\/hosting.blog\\\/#\\\/schema\\\/person\\\/8eeb0eb551a41b1fd6211ee4c7bee5d4\",\"name\":\"pandemia\",\"sameAs\":[\"http:\\\/\\\/www.pandemiahosting.com\"],\"url\":\"https:\\\/\\\/www.pandemiahosting.com\\\/hosting.blog\\\/author\\\/pandemia\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Optimizar Magento","description":"Optimizar Magento para que cargue mas rapido","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.pandemiahosting.com\/hosting.blog\/optimizar-magento\/","og_locale":"es_ES","og_type":"article","og_title":"Optimizar Magento","og_description":"Optimizar Magento para que cargue mas rapido","og_url":"https:\/\/www.pandemiahosting.com\/hosting.blog\/optimizar-magento\/","og_site_name":"Blog Pandemia Hosting","article_publisher":"https:\/\/www.facebook.com\/pandemiahosting","article_published_time":"2014-10-04T15:02:34+00:00","og_image":[{"width":318,"height":100,"url":"https:\/\/www.pandemiahosting.com\/hosting.blog\/wp-content\/uploads\/2014\/10\/magento-optimizacion.png","type":"image\/png"}],"author":"pandemia","twitter_card":"summary_large_image","twitter_creator":"@pandemiahosting","twitter_site":"@pandemiahosting","twitter_misc":{"Escrito por":"pandemia","Tiempo de lectura":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.pandemiahosting.com\/hosting.blog\/optimizar-magento\/#article","isPartOf":{"@id":"https:\/\/www.pandemiahosting.com\/hosting.blog\/optimizar-magento\/"},"author":{"name":"pandemia","@id":"https:\/\/www.pandemiahosting.com\/hosting.blog\/#\/schema\/person\/8eeb0eb551a41b1fd6211ee4c7bee5d4"},"headline":"Optimizar Magento","datePublished":"2014-10-04T15:02:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.pandemiahosting.com\/hosting.blog\/optimizar-magento\/"},"wordCount":775,"image":{"@id":"https:\/\/www.pandemiahosting.com\/hosting.blog\/optimizar-magento\/#primaryimage"},"thumbnailUrl":"https:\/\/www.pandemiahosting.com\/hosting.blog\/wp-content\/uploads\/2014\/10\/magento-optimizacion.png","keywords":["magento","optimizar magento","vps magento"],"articleSection":["Magento"],"inLanguage":"es"},{"@type":"WebPage","@id":"https:\/\/www.pandemiahosting.com\/hosting.blog\/optimizar-magento\/","url":"https:\/\/www.pandemiahosting.com\/hosting.blog\/optimizar-magento\/","name":"Optimizar Magento","isPartOf":{"@id":"https:\/\/www.pandemiahosting.com\/hosting.blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.pandemiahosting.com\/hosting.blog\/optimizar-magento\/#primaryimage"},"image":{"@id":"https:\/\/www.pandemiahosting.com\/hosting.blog\/optimizar-magento\/#primaryimage"},"thumbnailUrl":"https:\/\/www.pandemiahosting.com\/hosting.blog\/wp-content\/uploads\/2014\/10\/magento-optimizacion.png","datePublished":"2014-10-04T15:02:34+00:00","author":{"@id":"https:\/\/www.pandemiahosting.com\/hosting.blog\/#\/schema\/person\/8eeb0eb551a41b1fd6211ee4c7bee5d4"},"description":"Optimizar Magento para que cargue mas rapido","inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pandemiahosting.com\/hosting.blog\/optimizar-magento\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.pandemiahosting.com\/hosting.blog\/optimizar-magento\/#primaryimage","url":"https:\/\/www.pandemiahosting.com\/hosting.blog\/wp-content\/uploads\/2014\/10\/magento-optimizacion.png","contentUrl":"https:\/\/www.pandemiahosting.com\/hosting.blog\/wp-content\/uploads\/2014\/10\/magento-optimizacion.png","width":318,"height":100,"caption":"optimizacion magento"},{"@type":"WebSite","@id":"https:\/\/www.pandemiahosting.com\/hosting.blog\/#website","url":"https:\/\/www.pandemiahosting.com\/hosting.blog\/","name":"Blog Pandemia Hosting","description":"Hosting en Uruguay","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.pandemiahosting.com\/hosting.blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/www.pandemiahosting.com\/hosting.blog\/#\/schema\/person\/8eeb0eb551a41b1fd6211ee4c7bee5d4","name":"pandemia","sameAs":["http:\/\/www.pandemiahosting.com"],"url":"https:\/\/www.pandemiahosting.com\/hosting.blog\/author\/pandemia\/"}]}},"_links":{"self":[{"href":"https:\/\/www.pandemiahosting.com\/hosting.blog\/wp-json\/wp\/v2\/posts\/711","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pandemiahosting.com\/hosting.blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.pandemiahosting.com\/hosting.blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.pandemiahosting.com\/hosting.blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pandemiahosting.com\/hosting.blog\/wp-json\/wp\/v2\/comments?post=711"}],"version-history":[{"count":10,"href":"https:\/\/www.pandemiahosting.com\/hosting.blog\/wp-json\/wp\/v2\/posts\/711\/revisions"}],"predecessor-version":[{"id":722,"href":"https:\/\/www.pandemiahosting.com\/hosting.blog\/wp-json\/wp\/v2\/posts\/711\/revisions\/722"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pandemiahosting.com\/hosting.blog\/wp-json\/wp\/v2\/media\/712"}],"wp:attachment":[{"href":"https:\/\/www.pandemiahosting.com\/hosting.blog\/wp-json\/wp\/v2\/media?parent=711"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pandemiahosting.com\/hosting.blog\/wp-json\/wp\/v2\/categories?post=711"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pandemiahosting.com\/hosting.blog\/wp-json\/wp\/v2\/tags?post=711"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}