{"id":1369142,"date":"2017-10-26T07:03:00","date_gmt":"2017-10-26T14:03:00","guid":{"rendered":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/long-import-time-and-slow-page-call\/"},"modified":"2017-10-26T07:03:00","modified_gmt":"2017-10-26T14:03:00","slug":"long-import-time-and-slow-page-call","status":"closed","type":"topic","link":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/long-import-time-and-slow-page-call\/","title":{"rendered":"long import time and slow page call"},"content":{"rendered":"<p>WordPress-Version: 4.8.2<br \/>\nTheme: ColorMag Pro<br \/>\naffected Plugins: The Event Calendar (4.6.2), Event Calendar Pro (4.4.18), WP All import (4.5.0)<\/p>\n<p>We are importing xml files (Events with 15 different fields) with the Plugin \u201cWP ALL import\u201d to \u201cThe Event Calendar\u201d as events.<br \/>\nWe have created 4 custom fields in The Event Calendar and for the rest we are using the standard fields like (_EventStartDate, _EventURL \u2026and so on).<\/p>\n<p>The event place is a custom field because there is no manual mapping possible between event place and event. During import the event place is matched with the event.<\/p>\n<p>We have tried to import about 30.000 events at once. And realized that it takes very long (13 hours). During import the load of an event page was very slow (approx. 30 seconds).<br \/>\nAfter the import the loading of the pages (single event) of the website was still very slow (30 seconds).<br \/>\nDuring import the workload of the processor of the webserver was 15%. RAM was not oursourced.<br \/>\nServer RAM is 7GB and hard drive 20 GB (MySQL database).<br \/>\nRestart of database server was done but made no change.<\/p>\n<p>Then we have reduced the number of events to 2.000 and it took 15 minutes. The load of an event page was much faster (2 seconds).<\/p>\n<p>Do have the number of categories per event an impact on the performance?<br \/>\nHow many events can be imported that we have no loading problems?<\/p>\n","protected":false},"template":"","class_list":["post-1369142","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>long import time and slow page call -<\/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\/long-import-time-and-slow-page-call\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"long import time and slow page call -\" \/>\n<meta property=\"og:description\" content=\"WordPress-Version: 4.8.2 Theme: ColorMag Pro affected Plugins: The Event Calendar (4.6.2), Event Calendar Pro (4.4.18), WP All import (4.5.0) We are importing xml files (Events with 15 different fields) with the Plugin \u201cWP ALL import\u201d to \u201cThe Event Calendar\u201d as events. We have created 4 custom fields in The Event Calendar and for the rest [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/long-import-time-and-slow-page-call\/\" \/>\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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/long-import-time-and-slow-page-call\/\",\"url\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/long-import-time-and-slow-page-call\/\",\"name\":\"long import time and slow page call -\",\"isPartOf\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\"},\"datePublished\":\"2017-10-26T14:03:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/long-import-time-and-slow-page-call\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/long-import-time-and-slow-page-call\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/long-import-time-and-slow-page-call\/#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\":\"Events Calendar PRO\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/events-calendar-pro\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"long import time and slow page call\"}]},{\"@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":"long import time and slow page call -","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\/long-import-time-and-slow-page-call\/","og_locale":"en_US","og_type":"article","og_title":"long import time and slow page call -","og_description":"WordPress-Version: 4.8.2 Theme: ColorMag Pro affected Plugins: The Event Calendar (4.6.2), Event Calendar Pro (4.4.18), WP All import (4.5.0) We are importing xml files (Events with 15 different fields) with the Plugin \u201cWP ALL import\u201d to \u201cThe Event Calendar\u201d as events. We have created 4 custom fields in The Event Calendar and for the rest [&hellip;]","og_url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/long-import-time-and-slow-page-call\/","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/long-import-time-and-slow-page-call\/","url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/long-import-time-and-slow-page-call\/","name":"long import time and slow page call -","isPartOf":{"@id":"https:\/\/theeventscalendar.com\/support\/#website"},"datePublished":"2017-10-26T14:03:00+00:00","breadcrumb":{"@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/long-import-time-and-slow-page-call\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/theeventscalendar.com\/support\/forums\/topic\/long-import-time-and-slow-page-call\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/long-import-time-and-slow-page-call\/#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":"Events Calendar PRO","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/events-calendar-pro\/"},{"@type":"ListItem","position":5,"name":"long import time and slow page call"}]},{"@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\/1369142","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":0,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1369142\/revisions"}],"wp:attachment":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/media?parent=1369142"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}