{"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\/de\/blog\/magento\/how-to-speed-up-product-imports-and-exports-and-decrease-database-size\/","title":{"rendered":"Wie kann man Produktimporte und -exporte beschleunigen und die Datenbankgr\u00f6\u00dfe verringern?"},"content":{"rendered":"<p>Um den Import-\/Exportprozess von Magento-Produkten zu beschleunigen und die Datenbankgr\u00f6\u00dfe zu verringern. Bitte f\u00fchren Sie folgende Abfragen Ihrer Magento-Datenbank durch. Dadurch werden unn\u00f6tige Protokoll- und Indextabellen abgeschnitten.<\/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>Um den Import-\/Exportprozess von Magento-Produkten zu beschleunigen und die Datenbankgr\u00f6\u00dfe zu verringern. Bitte f\u00fchren Sie folgende Abfragen Ihrer Magento-Datenbank durch. Dadurch werden unn\u00f6tige Protokoll- und Indextabellen abgeschnitten. 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;\u2026<\/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\/de\/wp-json\/wp\/v2\/posts\/398"}],"collection":[{"href":"https:\/\/dknzdesign.com\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dknzdesign.com\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dknzdesign.com\/de\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/dknzdesign.com\/de\/wp-json\/wp\/v2\/comments?post=398"}],"version-history":[{"count":4,"href":"https:\/\/dknzdesign.com\/de\/wp-json\/wp\/v2\/posts\/398\/revisions"}],"predecessor-version":[{"id":412,"href":"https:\/\/dknzdesign.com\/de\/wp-json\/wp\/v2\/posts\/398\/revisions\/412"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dknzdesign.com\/de\/wp-json\/wp\/v2\/media\/411"}],"wp:attachment":[{"href":"https:\/\/dknzdesign.com\/de\/wp-json\/wp\/v2\/media?parent=398"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dknzdesign.com\/de\/wp-json\/wp\/v2\/categories?post=398"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dknzdesign.com\/de\/wp-json\/wp\/v2\/tags?post=398"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}