{"id":1186466,"date":"2016-11-02T10:21:53","date_gmt":"2016-11-02T17:21:53","guid":{"rendered":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/country-filter-in-filter-bar-possibly-still-borked\/"},"modified":"2016-11-03T13:06:34","modified_gmt":"2016-11-03T20:06:34","slug":"country-filter-in-filter-bar-possibly-still-borked","status":"closed","type":"topic","link":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/country-filter-in-filter-bar-possibly-still-borked\/","title":{"rendered":"Country Filter in Filter Bar possibly still borked"},"content":{"rendered":"<p>Per Nico&#8217;s guidance, I am pointing back to the original thread where this started, specifically regarding the possibility of internal support:<\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"hGODMAyNn9\"><p><a href=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/filter-bar-activated-okay-but-actual-event-content-in-main-views-disappear\/\">Filter Bar activated okay, but actual event content in main views disappear<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;Filter Bar activated okay, but actual event content in main views disappear&#8221; &#8212; \" src=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/filter-bar-activated-okay-but-actual-event-content-in-main-views-disappear\/embed\/#?secret=fQcGPjznz9#?secret=hGODMAyNn9\" data-secret=\"hGODMAyNn9\" width=\"580\" height=\"327\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<blockquote><p>Do you have a copy of the site in your local computer or just the live site? It would be interesting to see if you can reproduce this in more than one server to discard some config or resource limitation issues.<\/p>\n<p>Comparing the city, state and country filters, I see there\u2019s some extra code in the country one there are some operations to find the country name \/ code. I\u2019m mostly sure that part of the code is the one making the load time lot slower.<\/p><\/blockquote>\n<p>We took the site out of staging and into where it will be hosted live. It is at Liquid Web on a VPS with 512MB of a possible 1GB of memory behind it. <\/p>\n<p>Now, instead of just stopping in the process of rendering the page, it produces the page after 20-30s. And the filter works *amazingly* once it does load.<\/p>\n<p>Here&#8217;s the SQL dump: https:\/\/drive.google.com\/file\/d\/0BwzKIIobBLSaaUhGM3B0ckxKaWs\/view?usp=sharing (should be public).<\/p>\n<p>You guys still have an account you can use, but the domain name hasn&#8217;t been moved over yet, so the only way to access it is editing the hosts file and pointing to the numerical IP.<\/p>\n<p>There are 6000+ events, so I understand that it&#8217;s not necessarily going to be blazing fast, but is the addition of looking up country codes that much different from all the other evaluations?<\/p>\n<p>Since there are very few international events, proportionate to the whole, is there any way to maybe generate a whitelist for reference? Like, maybe I make a CRON that looks up which events have non-US locations each day, and point the filter bar to only return those? (Not asking for coding help, just wondering if such a customization is possible given the framework you guys have developed&#8230;a conceptual question)<\/p>\n<p>It&#8217;s become more important to my fearless leader that we make sure the Country filter actually works at the same zippiness and non-visitor-dissuading load times as the other filters. I can appreciate that there&#8217;s a lot for it to comb through, and that it&#8217;s at a different scale than perhaps this was designed for&#8230;and that adding double the power has helped the issue along considerably. But short of going full-crank on the RAM on the hosting, is there any way to optimize the situation as-is to maybe meet it part of the way there?<\/p>\n","protected":false},"template":"","class_list":["post-1186466","topic","type-topic","status-closed","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Country Filter in Filter Bar possibly still borked -<\/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:\/\/theeventscalendar.com\/support\/forums\/topic\/country-filter-in-filter-bar-possibly-still-borked\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Country Filter in Filter Bar possibly still borked -\" \/>\n<meta property=\"og:description\" content=\"Per Nico&#8217;s guidance, I am pointing back to the original thread where this started, specifically regarding the possibility of internal support: Filter Bar activated okay, but actual event content in main views disappear Do you have a copy of the site in your local computer or just the live site? It would be interesting to [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/country-filter-in-filter-bar-possibly-still-borked\/\" \/>\n<meta property=\"article:modified_time\" content=\"2016-11-03T20:06:34+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/country-filter-in-filter-bar-possibly-still-borked\/\",\"url\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/country-filter-in-filter-bar-possibly-still-borked\/\",\"name\":\"Country Filter in Filter Bar possibly still borked -\",\"isPartOf\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\"},\"datePublished\":\"2016-11-02T17:21:53+00:00\",\"dateModified\":\"2016-11-03T20:06:34+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/country-filter-in-filter-bar-possibly-still-borked\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/country-filter-in-filter-bar-possibly-still-borked\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/country-filter-in-filter-bar-possibly-still-borked\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/theeventscalendar.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Topics\",\"item\":\"https:\/\/theeventscalendar.com\/support\/topics\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Calendar Products\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Filter Bar\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/filter-bar\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Country Filter in Filter Bar possibly still borked\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\",\"url\":\"https:\/\/theeventscalendar.com\/support\/\",\"name\":\"\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/theeventscalendar.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Country Filter in Filter Bar possibly still borked -","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:\/\/theeventscalendar.com\/support\/forums\/topic\/country-filter-in-filter-bar-possibly-still-borked\/","og_locale":"en_US","og_type":"article","og_title":"Country Filter in Filter Bar possibly still borked -","og_description":"Per Nico&#8217;s guidance, I am pointing back to the original thread where this started, specifically regarding the possibility of internal support: Filter Bar activated okay, but actual event content in main views disappear Do you have a copy of the site in your local computer or just the live site? It would be interesting to [&hellip;]","og_url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/country-filter-in-filter-bar-possibly-still-borked\/","article_modified_time":"2016-11-03T20:06:34+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/country-filter-in-filter-bar-possibly-still-borked\/","url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/country-filter-in-filter-bar-possibly-still-borked\/","name":"Country Filter in Filter Bar possibly still borked -","isPartOf":{"@id":"https:\/\/theeventscalendar.com\/support\/#website"},"datePublished":"2016-11-02T17:21:53+00:00","dateModified":"2016-11-03T20:06:34+00:00","breadcrumb":{"@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/country-filter-in-filter-bar-possibly-still-borked\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/theeventscalendar.com\/support\/forums\/topic\/country-filter-in-filter-bar-possibly-still-borked\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/country-filter-in-filter-bar-possibly-still-borked\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/theeventscalendar.com\/support\/"},{"@type":"ListItem","position":2,"name":"Topics","item":"https:\/\/theeventscalendar.com\/support\/topics\/"},{"@type":"ListItem","position":3,"name":"Calendar Products","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/"},{"@type":"ListItem","position":4,"name":"Filter Bar","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/filter-bar\/"},{"@type":"ListItem","position":5,"name":"Country Filter in Filter Bar possibly still borked"}]},{"@type":"WebSite","@id":"https:\/\/theeventscalendar.com\/support\/#website","url":"https:\/\/theeventscalendar.com\/support\/","name":"","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/theeventscalendar.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1186466","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":1,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1186466\/revisions"}],"predecessor-version":[{"id":1187289,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1186466\/revisions\/1187289"}],"wp:attachment":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/media?parent=1186466"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}