{"id":398,"date":"2015-04-14T12:06:31","date_gmt":"2015-04-14T11:06:31","guid":{"rendered":"http:\/\/dknzdesign.com\/?p=398"},"modified":"2015-04-15T10:06:24","modified_gmt":"2015-04-15T09:06:24","slug":"how-to-speed-up-product-imports-and-exports-and-decrease-database-size","status":"publish","type":"post","link":"https:\/\/dknzdesign.com\/sl\/blog\/magento\/how-to-speed-up-product-imports-and-exports-and-decrease-database-size\/","title":{"rendered":"Kako pospe\u0161iti uvoz in izvoz izdelkov ter zmanj\u0161ati velikost baze podatkov?"},"content":{"rendered":"<p>To speed up magento products imports\/exports process and make database size decrease. Please run following queries of your magento database. It will truncate the unnecessary log and index tables.<\/p>\n<p>TRUNCATE dataflow_batch_export;<br \/>\nTRUNCATE dataflow_batch_import;<br \/>\nTRUNCATE log_customer;<br \/>\nTRUNCATE log_quote;<br \/>\nTRUNCATE log_summary;<br \/>\nTRUNCATE log_summary_type;<br \/>\nTRUNCATE log_url;<br \/>\nTRUNCATE log_url_info;<br \/>\nTRUNCATE log_visitor;<br \/>\nTRUNCATE log_visitor_info;<br \/>\nTRUNCATE log_visitor_online;<br \/>\nTRUNCATE report_viewed_product_index;<br \/>\nTRUNCATE report_compared_product_index;<br \/>\nTRUNCATE report_event;<br \/>\nTRUNCATE index_event;<br \/>\nTRUNCATE catalog_compare_item;<br \/>\nTRUNCATE catalogindex_aggregation;<br \/>\nTRUNCATE catalogindex_aggregation_tag;<br \/>\nTRUNCATE catalogindex_aggregation_to_tag;<\/p>","protected":false},"excerpt":{"rendered":"<p>To speed up magento products imports\/exports process and make database size decrease. Please run following queries of your magento database. It will truncate the unnecessary log and index tables. TRUNCATE dataflow_batch_export; TRUNCATE dataflow_batch_import; TRUNCATE log_customer; TRUNCATE log_quote; TRUNCATE log_summary; TRUNCATE log_summary_type; TRUNCATE log_url; TRUNCATE log_url_info; TRUNCATE log_visitor; TRUNCATE log_visitor_info; TRUNCATE log_visitor_online; TRUNCATE report_viewed_product_index; TRUNCATE report_compared_product_index;&#8230;<\/p>","protected":false},"author":2,"featured_media":411,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[40],"tags":[],"_links":{"self":[{"href":"https:\/\/dknzdesign.com\/sl\/wp-json\/wp\/v2\/posts\/398"}],"collection":[{"href":"https:\/\/dknzdesign.com\/sl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dknzdesign.com\/sl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dknzdesign.com\/sl\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/dknzdesign.com\/sl\/wp-json\/wp\/v2\/comments?post=398"}],"version-history":[{"count":4,"href":"https:\/\/dknzdesign.com\/sl\/wp-json\/wp\/v2\/posts\/398\/revisions"}],"predecessor-version":[{"id":412,"href":"https:\/\/dknzdesign.com\/sl\/wp-json\/wp\/v2\/posts\/398\/revisions\/412"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dknzdesign.com\/sl\/wp-json\/wp\/v2\/media\/411"}],"wp:attachment":[{"href":"https:\/\/dknzdesign.com\/sl\/wp-json\/wp\/v2\/media?parent=398"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dknzdesign.com\/sl\/wp-json\/wp\/v2\/categories?post=398"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dknzdesign.com\/sl\/wp-json\/wp\/v2\/tags?post=398"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}