{"id":4446,"date":"2016-09-28T09:46:59","date_gmt":"2016-09-28T13:46:59","guid":{"rendered":"https:\/\/saucal.com\/?p=4446"},"modified":"2025-04-02T20:00:01","modified_gmt":"2025-04-02T20:00:01","slug":"woocommerce-give-site-boost-actualizacion-gratuita","status":"publish","type":"post","link":"https:\/\/saucal.com\/es\/blog\/woocommerce-give-site-boost-actualizacion-gratuita\/","title":{"rendered":"\u00bfSufres de lentitud de b\u00fasqueda en WooCommerce?  Mejore su sitio con esta actualizaci\u00f3n gratuita"},"content":{"rendered":"<p><em>Este art\u00edculo apareci\u00f3 originalmente en\u00a0<a href=\"https:\/\/codeable.io\/large-woocommerce-search-faster\/?ref=VETbG\">Codificable<\/a>.<\/em><\/p>\n<p>Recientemente hemos experimentado algunos problemas graves con la b\u00fasqueda de WooCommerce en <a href=\"https:\/\/saucal.com\/es\/saucal-capta-consumidores-a-traves-de-woocommerce\/\">Sitios de comercio electr\u00f3nico<\/a> que procesan un gran n\u00famero de pedidos. Es necesario consultar la tabla postmeta cuando se busca un meta_valor espec\u00edfico, lo que provoca un <a href=\"https:\/\/saucal.com\/es\/woocommerce-lento\/\">ralentizaci\u00f3n importante de WooCommerce<\/a>. Por ejemplo, la consulta de la secci\u00f3n \"mis pedidos\" tardar\u00eda 5 s o incluso m\u00e1s, en funci\u00f3n del entorno del servidor. Por otra parte, la b\u00fasqueda en la pantalla \"Pedidos\" de los pedidos pertenecientes a un correo electr\u00f3nico o a una persona determinada puede durar 30 segundos o m\u00e1s (debido a la implicaci\u00f3n de JOIN adicionales en la tabla postmeta).<\/p>\n<p>Los dos ejemplos anteriores son inaceptables para un sitio web con gran cantidad de tr\u00e1fico y deb\u00edan solucionarse.<\/p>\n<h2><span id=\"current-solutions-and-associated-limitations\">Soluciones actuales y limitaciones asociadas<\/span><\/h2>\n<p>Tras investigar un poco, hemos descubierto que estos problemas se tratan actualmente de dos maneras:<\/p>\n<ul>\n<li class=\"translation-block\">utilizando <a href=\"https:\/\/www.elastic.co\/products\/elasticsearch\" target=\"_self\">ElasticSearch<\/a> para indexaci\u00f3n, con la ayuda del <a href=\"https:\/\/wordpress.org\/plugins\/elasticpress\/\" target=\"_self\">plugin ElasticPress<\/a>, o<\/li>\n<li>utilizando una tabla de \u00edndices secundaria dentro de la misma base de datos del sitio.<\/li>\n<\/ul>\n<p>La soluci\u00f3n ElasticSearch suena bien en teor\u00eda, pero nuestra experiencia nos lleva a creer que no es una buena cosa para integrar con WordPress. Esto se debe al enorme n\u00famero de diferencias entre la fuente de datos base de WP (que son tablas MySQL) y los \u00edndices de ElasticSearch.<\/p>\n<p>Aunque ElasticSearch realiza muy bien las b\u00fasquedas parciales y es bastante bueno a la hora de \"adivinar\" lo que se pretende escribir en la consulta de b\u00fasqueda, estas peque\u00f1as ventajas definitivamente no se ven compensadas por los inconvenientes de integrar estas dos fuentes de datos:<\/p>\n<ul>\n<li>latencia entre la instancia de ElasticSearch y su proveedor de alojamiento (tenga en cuenta que esto no ser\u00e1 un problema si tiene ElasticPress instalado en el mismo servidor que su entorno PHP, pero esto no es un escenario com\u00fan con las soluciones actuales de alojamiento gestionado de WordPress), y<\/li>\n<li>el n\u00famero de pedidos incluidos en cada resultado (en todas las p\u00e1ginas) se reduce a un par de centenares.<\/li>\n<\/ul>\n<p>En este caso, tendr\u00edamos que consultar la instancia de ElasticSearch y luego pasar los IDs de entradas coincidentes a WP_Query (respetando la longitud m\u00e1xima de la consulta SQL que se env\u00eda a MySQL). Esto rompe el flujo de trabajo para b\u00fasquedas de amplio rango, y podr\u00eda potencialmente proporcionar un n\u00famero enga\u00f1oso de resultados totales al administrador de la tienda que busca en la pantalla de Pedidos.<\/p>\n<p class=\"translation-block\">Ahora, pasemos a la tabla de \u00edndice secundaria. La soluci\u00f3n original nos fue presentada por <a target=\"_blank\" href=\"https:\/\/garman.io\/\" rel=\"noopener\">Patrick Garman<\/a>, un compa\u00f1ero desarrollador de WordPress. Su intenci\u00f3n original era simplemente mejorar la secci\u00f3n \u201cMis Pedidos\u201d de WooCommerce, pero pensamos que esto se quedaba un poco corto para nuestras necesidades.<\/p>\n<p>Sabemos que su implementaci\u00f3n actual es s\u00f3lo una soluci\u00f3n temporal hasta el lanzamiento de WooCommerce 3.0 y la enorme renovaci\u00f3n de la base de datos que est\u00e1 prevista para ello (que solucionar\u00e1 los problemas que estamos discutiendo en este post). Tambi\u00e9n sabemos que WC 3.0 no est\u00e1 programado para ser lanzado hasta mediados de 2017, y ya que tenemos que hacer felices a nuestros clientes antes de entonces, <a target=\"_blank\" href=\"https:\/\/github.com\/saucal\/wc-customer-order-index\" rel=\"noopener\">hemos bifurcado la implementaci\u00f3n de Patrick<\/a>.<\/p>\n<h2><span id=\"our-proposed-solution\">Nuestra soluci\u00f3n propuesta<\/span><\/h2>\n<p>La implementaci\u00f3n original del \u00edndice de pedidos s\u00f3lo indexa los ID de los pedidos y los ID de los clientes en una tabla secundaria (que es lo que Patrick se propuso arreglar). Su soluci\u00f3n es modificar la WP_Query \"Mis Pedidos\" para utilizar su \u00edndice.<\/p>\n<p>Lo ampliamos de varias maneras:<\/p>\n<ol>\n<li>Hemos incluido los correos electr\u00f3nicos de los clientes (tanto el correo electr\u00f3nico de facturaci\u00f3n del pedido como el correo electr\u00f3nico del cliente que se deriva del cliente asignado al pedido). Siempre que busque un correo electr\u00f3nico en la vista de pedidos de la secci\u00f3n de administraci\u00f3n, activamos el uso del \u00edndice en lugar de postmeta.<\/li>\n<li>Hemos incluido los nombres de los clientes (facturaci\u00f3n, env\u00edo y nombre para mostrar del cliente asignado).<\/li>\n<\/ol>\n<p>Aqu\u00ed nos encontramos con un problema; no queremos eliminar completamente las funciones de b\u00fasqueda existentes de WooCommerce, pero necesitamos tener alguna forma de usar el \u00edndice condicionalmente para b\u00fasquedas m\u00e1s r\u00e1pidas. Esto se debe a que nuestro \u00edndice no soporta la b\u00fasqueda por direcci\u00f3n, por ejemplo, y la funcionalidad de WooCommerce cubre eso.<\/p>\n<p>Para conseguirlo, hemos incluido un par\u00e1metro como b\u00fasqueda. Siempre que su par\u00e1metro de b\u00fasqueda sea \"name:John D\", le devolveremos todos los pedidos con nombres que coincidan con John D utilizando una b\u00fasqueda comod\u00edn. Podr\u00edas buscar por el ID del pedido en WooCommerce pero pensamos que pod\u00edamos hacerlo m\u00e1s f\u00e1cil, as\u00ed que con nuestra soluci\u00f3n, puedes simplemente introducir el t\u00e9rmino de b\u00fasqueda \"#1456\" y te devolveremos el pedido 1456.<\/p>\n<h2><span id=\"how-to-implement-it\">C\u00f3mo aplicarlo<\/span><\/h2>\n<p>Para instalar este \u00edndice, todo lo que tienes que hacer es instalar nuestro fork del plugin y luego habilitarlo. Aqu\u00ed est\u00e1 la URL: <a target=\"_blank\" href=\"https:\/\/github.com\/saucal\/wc-customer-order-index\" rel=\"noopener\">https:\/\/github.com\/saucal\/wc-customer-order-index<\/a><\/p>\n<p>La \u00fanica complicaci\u00f3n por el momento es que necesitas acceso a WP-CLI para crear el \u00edndice inicial. Estamos trabajando en habilitar una interfaz AJAX que le permitir\u00e1 construir el \u00edndice sin WP-CLI.<\/p>\n<p>Por ahora, despu\u00e9s de activar el plugin, necesitas abrir tu interfaz WP-CLI e introducir el comando \"wp wc_coi reset_index\" para que empiece a generar el \u00edndice por ti. El tiempo que tarde este proceso variar\u00e1 en funci\u00f3n del n\u00famero de pedidos que tenga en su sitio.<\/p>\n<h2><span id=\"how-things-have-changed\">C\u00f3mo han cambiado las cosas<\/span><\/h2>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-4448\" src=\"https:\/\/saucal.com\/wp-content\/uploads\/sites\/2\/2016\/09\/WooCommerce-search-before.jpg?resize=1024%2C402\" alt=\"WooCommerce Buscar Antes\" width=\"1024\" height=\"402\" \/><\/p>\n<p>Con el uso de este plugin, hemos podido mejorar enormemente el rendimiento de las grandes tiendas de nuestros clientes. Aqu\u00ed arriba puedes ver un ejemplo en el que el tiempo era de casi 40 segundos. En uno de nuestros casos de peor rendimiento, la b\u00fasqueda de correo electr\u00f3nico en WP-Admin tardaba m\u00e1s de 50 segundos.<\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-4447\" src=\"https:\/\/saucal.com\/wp-content\/uploads\/sites\/2\/2016\/09\/WooCommerce-search-after.jpg?resize=1024%2C403\" alt=\"WooCommerce Buscar Despu\u00e9s\" width=\"1024\" height=\"403\" \/><\/p>\n<p>Utilizando este plugin, hemos reducido el tiempo de b\u00fasqueda a menos de 5 segundos, \u00a1mejor\u00e1ndolo en 867%!<\/p>\n<h2><span id=\"wrapping-things-up\">Para terminar<\/span><\/h2>\n<p>Probamos la soluci\u00f3n ElasticSearch para uno de nuestros clientes y ten\u00eda demasiadas partes m\u00f3viles para nuestro gusto. Preferimos algo que se mantenga dentro del \u00e1mbito de WordPress y no requiera que nuestros clientes se den de alta en ning\u00fan servicio externo.<\/p>\n<p>Para ser claros, esto no es un problema de ElasticSearch como tecnolog\u00eda. Es s\u00f3lo que es demasiado diferente de c\u00f3mo funciona WordPress, por lo que la integraci\u00f3n de los dos cre\u00f3 algunas desventajas que para nosotros eran deal breakers teniendo en cuenta lo que est\u00e1bamos tratando de lograr. Adem\u00e1s, tuvimos que recurrir a un complejo plugin de terceros (ElasticPress de 10up).<\/p>\n<p>Hemos iterado sobre el enfoque de Patrick y lo hemos ampliado para satisfacer las necesidades m\u00e1s comunes de nuestros clientes. Como agencia de confianza de WordPress, sabemos que esta no es la soluci\u00f3n m\u00e1s bonita, ya que duplica muchos de los datos. S\u00f3lo queremos proporcionar a nuestros clientes una soluci\u00f3n s\u00f3lida hasta que WooCommerce 3.0 sea lanzado y haga esta soluci\u00f3n innecesaria.<\/p>\n<p class=\"translation-block\">\u00bfHabr\u00edas hecho algo diferente? No dudes en enviarnos un pull request <a target=\"_blank\" href=\"https:\/\/github.com\/saucal\/wc-customer-order-index\" rel=\"noopener\">en nuestro repositorio<\/a>, \u00a1nos encantar\u00eda ver alternativas!<\/p>\n<p class=\"translation-block\"><em>\u00a1Choca esos cinco con nuestro desarrollador principal <a href=\"https:\/\/saucal.com\/es\/marketing\/meet-the-nerds\/#matias-saggiorato\" target=\"_self\">Matias<\/a> por ayudarme con este art\u00edculo!<\/em><\/p>","protected":false},"excerpt":{"rendered":"<p>This post originally appeared on\u00a0Codeable. We&#8217;ve recently experienced some serious issues with WooCommerce search on eCommerce sites that process a large number of orders. The postmeta table needs to be queried when looking for a specific meta_value, which causes a major WooCommerce slowdown. For example, querying the &#8220;my orders&#8221; section would take 5s or possibly [&hellip;]<\/p>\n","protected":false},"author":19,"featured_media":24563,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[942,76],"tags":[49,50,51],"class_list":["post-4446","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-woocommerce-performance","category-woocommerce-tutorials","tag-optimization","tag-scaling","tag-search"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.6 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Suffering from Slow Search Speeds in WooCommerce? Give Your Site a Boost with this Free Upgrade - Saucal<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/codeable.io\/large-woocommerce-search-faster\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Suffering from Slow Search Speeds in WooCommerce? Give Your Site a Boost with this Free Upgrade - Saucal\" \/>\n<meta property=\"og:description\" content=\"This post originally appeared on\u00a0Codeable. We&#8217;ve recently experienced some serious issues with WooCommerce search on eCommerce sites that process a large number of orders. The postmeta table needs to be queried when looking for a specific meta_value, which causes a major WooCommerce slowdown. For example, querying the &#8220;my orders&#8221; section would take 5s or possibly [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/codeable.io\/large-woocommerce-search-faster\/\" \/>\n<meta property=\"og:site_name\" content=\"Saucal\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Saucal\/\" \/>\n<meta property=\"article:published_time\" content=\"2016-09-28T13:46:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-02T20:00:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/saucal.com\/wp-content\/uploads\/sites\/2\/2024\/10\/Page-promo-image-HP.png?fit=1200%2C630\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Mitchell Callahan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@Saucal\" \/>\n<meta name=\"twitter:site\" content=\"@Saucal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mitchell Callahan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/codeable.io\\\/large-woocommerce-search-faster\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/saucal.com\\\/blog\\\/suffering-slow-search-speeds-woocommerce-give-site-boost-free-upgrade\\\/\"},\"author\":{\"name\":\"Mitchell Callahan\",\"@id\":\"https:\\\/\\\/saucal.com\\\/#\\\/schema\\\/person\\\/70c41987f7db3fdb892c77112c44bf4a\"},\"headline\":\"Suffering from Slow Search Speeds in WooCommerce? Give Your Site a Boost with this Free Upgrade\",\"datePublished\":\"2016-09-28T13:46:59+00:00\",\"dateModified\":\"2025-04-02T20:00:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/saucal.com\\\/blog\\\/suffering-slow-search-speeds-woocommerce-give-site-boost-free-upgrade\\\/\"},\"wordCount\":1132,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/saucal.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/codeable.io\\\/large-woocommerce-search-faster\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/saucal.com\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2019\\\/10\\\/rectangle-placeholder.svg\",\"keywords\":[\"optimization\",\"scaling\",\"search\"],\"articleSection\":[\"WooCommerce Performance\",\"WooCommerce Tutorials\"],\"inLanguage\":\"es-ES\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/codeable.io\\\/large-woocommerce-search-faster\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/saucal.com\\\/blog\\\/suffering-slow-search-speeds-woocommerce-give-site-boost-free-upgrade\\\/\",\"url\":\"https:\\\/\\\/codeable.io\\\/large-woocommerce-search-faster\\\/\",\"name\":\"Suffering from Slow Search Speeds in WooCommerce? Give Your Site a Boost with this Free Upgrade - Saucal\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/saucal.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/codeable.io\\\/large-woocommerce-search-faster\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/codeable.io\\\/large-woocommerce-search-faster\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/saucal.com\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2019\\\/10\\\/rectangle-placeholder.svg\",\"datePublished\":\"2016-09-28T13:46:59+00:00\",\"dateModified\":\"2025-04-02T20:00:01+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/codeable.io\\\/large-woocommerce-search-faster\\\/#breadcrumb\"},\"inLanguage\":\"es-ES\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/codeable.io\\\/large-woocommerce-search-faster\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es-ES\",\"@id\":\"https:\\\/\\\/codeable.io\\\/large-woocommerce-search-faster\\\/#primaryimage\",\"url\":\"https:\\\/\\\/saucal.com\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2019\\\/10\\\/rectangle-placeholder.svg\",\"contentUrl\":\"https:\\\/\\\/saucal.com\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2019\\\/10\\\/rectangle-placeholder.svg\",\"width\":380,\"height\":230},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/codeable.io\\\/large-woocommerce-search-faster\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/saucal.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Suffering from Slow Search Speeds in WooCommerce? Give Your Site a Boost with this Free Upgrade\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/saucal.com\\\/#website\",\"url\":\"https:\\\/\\\/saucal.com\\\/\",\"name\":\"Saucal\",\"description\":\"Your eCommerce Architechs\",\"publisher\":{\"@id\":\"https:\\\/\\\/saucal.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/saucal.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es-ES\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/saucal.com\\\/#organization\",\"name\":\"Saucal\",\"url\":\"https:\\\/\\\/saucal.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es-ES\",\"@id\":\"https:\\\/\\\/saucal.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/saucal.com\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/10\\\/saucal-logo.svg\",\"contentUrl\":\"https:\\\/\\\/saucal.com\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/10\\\/saucal-logo.svg\",\"width\":75,\"height\":75,\"caption\":\"Saucal\"},\"image\":{\"@id\":\"https:\\\/\\\/saucal.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/Saucal\\\/\",\"https:\\\/\\\/x.com\\\/Saucal\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/1984234\\\/\",\"https:\\\/\\\/www.instagram.com\\\/saucal\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/saucal.com\\\/#\\\/schema\\\/person\\\/70c41987f7db3fdb892c77112c44bf4a\",\"name\":\"Mitchell Callahan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es-ES\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5e31ff50957a54a0caed40ccce4924cf3266984883fd2a4ba6f1be269a02ee87?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5e31ff50957a54a0caed40ccce4924cf3266984883fd2a4ba6f1be269a02ee87?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5e31ff50957a54a0caed40ccce4924cf3266984883fd2a4ba6f1be269a02ee87?s=96&d=mm&r=g\",\"caption\":\"Mitchell Callahan\"},\"description\":\"Known as \\\"The Boundary Pusher,\\\" is the Commander at Saucal. Born in Yellowknife, NT, Canada, his early passion for the internet began in the mid-90s, where he became hooked on technology, starting with dial-up and local online communities like North of 60.\",\"url\":\"https:\\\/\\\/saucal.com\\\/es\\\/blog\\\/author\\\/m-ceo\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u00bfSufres de lentitud de b\u00fasqueda en WooCommerce? Mejore su sitio web con esta actualizaci\u00f3n gratuita - Saucal","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:\/\/codeable.io\/large-woocommerce-search-faster\/","og_locale":"es_ES","og_type":"article","og_title":"Suffering from Slow Search Speeds in WooCommerce? Give Your Site a Boost with this Free Upgrade - Saucal","og_description":"This post originally appeared on\u00a0Codeable. We&#8217;ve recently experienced some serious issues with WooCommerce search on eCommerce sites that process a large number of orders. The postmeta table needs to be queried when looking for a specific meta_value, which causes a major WooCommerce slowdown. For example, querying the &#8220;my orders&#8221; section would take 5s or possibly [&hellip;]","og_url":"https:\/\/codeable.io\/large-woocommerce-search-faster\/","og_site_name":"Saucal","article_publisher":"https:\/\/www.facebook.com\/Saucal\/","article_published_time":"2016-09-28T13:46:59+00:00","article_modified_time":"2025-04-02T20:00:01+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/saucal.com\/wp-content\/uploads\/sites\/2\/2024\/10\/Page-promo-image-HP.png?fit=1200%2C630","type":"image\/png"}],"author":"Mitchell Callahan","twitter_card":"summary_large_image","twitter_creator":"@Saucal","twitter_site":"@Saucal","twitter_misc":{"Written by":"Mitchell Callahan","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/codeable.io\/large-woocommerce-search-faster\/#article","isPartOf":{"@id":"https:\/\/saucal.com\/blog\/suffering-slow-search-speeds-woocommerce-give-site-boost-free-upgrade\/"},"author":{"name":"Mitchell Callahan","@id":"https:\/\/saucal.com\/#\/schema\/person\/70c41987f7db3fdb892c77112c44bf4a"},"headline":"Suffering from Slow Search Speeds in WooCommerce? Give Your Site a Boost with this Free Upgrade","datePublished":"2016-09-28T13:46:59+00:00","dateModified":"2025-04-02T20:00:01+00:00","mainEntityOfPage":{"@id":"https:\/\/saucal.com\/blog\/suffering-slow-search-speeds-woocommerce-give-site-boost-free-upgrade\/"},"wordCount":1132,"commentCount":0,"publisher":{"@id":"https:\/\/saucal.com\/#organization"},"image":{"@id":"https:\/\/codeable.io\/large-woocommerce-search-faster\/#primaryimage"},"thumbnailUrl":"https:\/\/saucal.com\/wp-content\/uploads\/sites\/2\/2019\/10\/rectangle-placeholder.svg","keywords":["optimization","scaling","search"],"articleSection":["WooCommerce Performance","WooCommerce Tutorials"],"inLanguage":"es-ES","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/codeable.io\/large-woocommerce-search-faster\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/saucal.com\/blog\/suffering-slow-search-speeds-woocommerce-give-site-boost-free-upgrade\/","url":"https:\/\/codeable.io\/large-woocommerce-search-faster\/","name":"\u00bfSufres de lentitud de b\u00fasqueda en WooCommerce? Mejore su sitio web con esta actualizaci\u00f3n gratuita - Saucal","isPartOf":{"@id":"https:\/\/saucal.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/codeable.io\/large-woocommerce-search-faster\/#primaryimage"},"image":{"@id":"https:\/\/codeable.io\/large-woocommerce-search-faster\/#primaryimage"},"thumbnailUrl":"https:\/\/saucal.com\/wp-content\/uploads\/sites\/2\/2019\/10\/rectangle-placeholder.svg","datePublished":"2016-09-28T13:46:59+00:00","dateModified":"2025-04-02T20:00:01+00:00","breadcrumb":{"@id":"https:\/\/codeable.io\/large-woocommerce-search-faster\/#breadcrumb"},"inLanguage":"es-ES","potentialAction":[{"@type":"ReadAction","target":["https:\/\/codeable.io\/large-woocommerce-search-faster\/"]}]},{"@type":"ImageObject","inLanguage":"es-ES","@id":"https:\/\/codeable.io\/large-woocommerce-search-faster\/#primaryimage","url":"https:\/\/saucal.com\/wp-content\/uploads\/sites\/2\/2019\/10\/rectangle-placeholder.svg","contentUrl":"https:\/\/saucal.com\/wp-content\/uploads\/sites\/2\/2019\/10\/rectangle-placeholder.svg","width":380,"height":230},{"@type":"BreadcrumbList","@id":"https:\/\/codeable.io\/large-woocommerce-search-faster\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/saucal.com\/"},{"@type":"ListItem","position":2,"name":"Suffering from Slow Search Speeds in WooCommerce? Give Your Site a Boost with this Free Upgrade"}]},{"@type":"WebSite","@id":"https:\/\/saucal.com\/#website","url":"https:\/\/saucal.com\/","name":"Saucal","description":"Sus arquitectos de comercio electr\u00f3nico","publisher":{"@id":"https:\/\/saucal.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/saucal.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es-ES"},{"@type":"Organization","@id":"https:\/\/saucal.com\/#organization","name":"Saucal","url":"https:\/\/saucal.com\/","logo":{"@type":"ImageObject","inLanguage":"es-ES","@id":"https:\/\/saucal.com\/#\/schema\/logo\/image\/","url":"https:\/\/saucal.com\/wp-content\/uploads\/sites\/2\/2024\/10\/saucal-logo.svg","contentUrl":"https:\/\/saucal.com\/wp-content\/uploads\/sites\/2\/2024\/10\/saucal-logo.svg","width":75,"height":75,"caption":"Saucal"},"image":{"@id":"https:\/\/saucal.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/Saucal\/","https:\/\/x.com\/Saucal","https:\/\/www.linkedin.com\/company\/1984234\/","https:\/\/www.instagram.com\/saucal\/"]},{"@type":"Person","@id":"https:\/\/saucal.com\/#\/schema\/person\/70c41987f7db3fdb892c77112c44bf4a","name":"Mitchell Callahan","image":{"@type":"ImageObject","inLanguage":"es-ES","@id":"https:\/\/secure.gravatar.com\/avatar\/5e31ff50957a54a0caed40ccce4924cf3266984883fd2a4ba6f1be269a02ee87?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/5e31ff50957a54a0caed40ccce4924cf3266984883fd2a4ba6f1be269a02ee87?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5e31ff50957a54a0caed40ccce4924cf3266984883fd2a4ba6f1be269a02ee87?s=96&d=mm&r=g","caption":"Mitchell Callahan"},"description":"Conocido como \"El Empujador de Fronteras\", es el Comandante de Saucal. Nacido en Yellowknife (NT, Canad\u00e1), su temprana pasi\u00f3n por Internet comenz\u00f3 a mediados de los 90, cuando se enganch\u00f3 a la tecnolog\u00eda, empezando por la conexi\u00f3n telef\u00f3nica y las comunidades locales en l\u00ednea como North of 60.","url":"https:\/\/saucal.com\/es\/blog\/author\/m-ceo\/"}]}},"jetpack_featured_media_url":"https:\/\/saucal.com\/wp-content\/uploads\/sites\/2\/2019\/10\/rectangle-placeholder.svg","get_sub_heading":"","get_post_reading_time":"\t\t<div id=\"reading_4446\" class=\"post-reading-time\">\n\t\t\t<p class=\"post-reading-time__text\">6 Min Read<\/p>\n\t\t<\/div>\n\t\t","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/saucal.com\/es\/wp-json\/wp\/v2\/posts\/4446","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/saucal.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/saucal.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/saucal.com\/es\/wp-json\/wp\/v2\/users\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/saucal.com\/es\/wp-json\/wp\/v2\/comments?post=4446"}],"version-history":[{"count":1,"href":"https:\/\/saucal.com\/es\/wp-json\/wp\/v2\/posts\/4446\/revisions"}],"predecessor-version":[{"id":8448,"href":"https:\/\/saucal.com\/es\/wp-json\/wp\/v2\/posts\/4446\/revisions\/8448"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/saucal.com\/es\/wp-json\/wp\/v2\/media\/24563"}],"wp:attachment":[{"href":"https:\/\/saucal.com\/es\/wp-json\/wp\/v2\/media?parent=4446"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/saucal.com\/es\/wp-json\/wp\/v2\/categories?post=4446"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/saucal.com\/es\/wp-json\/wp\/v2\/tags?post=4446"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}