Title: Database Optimization
Last modified: March 14, 2018

---

# Database Optimization

 *  Resolved [vurdalak](https://wordpress.org/support/users/vurdalak/)
 * (@vurdalak)
 * [8 years, 3 months ago](https://wordpress.org/support/topic/database-optimization-2/)
 * Hi, i have some big csv files with aprox (40,000) woocommerce products. All work
   fine. But each time when i update this files (make some changes in columns) database
   increase. How i can resolve this issue?

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Plugin Author [WP All Import](https://wordpress.org/support/users/wpallimport/)
 * (@wpallimport)
 * [8 years, 2 months ago](https://wordpress.org/support/topic/database-optimization-2/#post-10087583)
 * Hey [@vurdalak](https://wordpress.org/support/users/vurdalak/)
 * If you import new data, then it would be expected that it’s added to the database,
   and the database will grow in size as a result. Or, are you saying that there’s
   unnecessary data that’s being added? If so, can you please elaborate on the data
   and where it’s being added in the database?
 *  Thread Starter [vurdalak](https://wordpress.org/support/users/vurdalak/)
 * (@vurdalak)
 * [8 years, 2 months ago](https://wordpress.org/support/topic/database-optimization-2/#post-10087619)
 * Hi, initial i added csv file with aprox. 40,000 product. after that i needed 
   to do some changes like remove available quantity and mark all products “in stock”
   i make this changes and make update of this file. Next update i make because 
   some data was changed by excel when i edit file and i see it when update was 
   done. the last time when i upload the new file with the same quantity of products,
   and only one change in wp all import i make (added SEO for Image- Alternative
   Text) my database increase from 750mb to 1.5GB (total was like 150,000 total 
   products). After last updata of file with 40,000 products database increase.
 *  Thread Starter [vurdalak](https://wordpress.org/support/users/vurdalak/)
 * (@vurdalak)
 * [8 years, 2 months ago](https://wordpress.org/support/topic/database-optimization-2/#post-10098142)
 * Any suggestion what i can do incorrect?
 *  Plugin Author [WP All Import](https://wordpress.org/support/users/wpallimport/)
 * (@wpallimport)
 * [8 years, 2 months ago](https://wordpress.org/support/topic/database-optimization-2/#post-10109161)
 * Hi [@vurdalak](https://wordpress.org/support/users/vurdalak/).
 * It’s hard to say what caused such an increase in size. We’ll need to see your
   import settings and data to advise on this. Please reproduce your import at [http://www.wpallimport.com/debug/](http://www.wpallimport.com/debug/)
   and open a ticket at [http://www.wpallimport.com/support/](http://www.wpallimport.com/support/)
   so that we can have a look.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Database Optimization’ is closed to new replies.

 * ![](https://ps.w.org/woocommerce-xml-csv-product-import/assets/icon-256x256.png?
   rev=2570167)
 * [WP All Import – Product Import for WooCommerce](https://wordpress.org/plugins/woocommerce-xml-csv-product-import/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce-xml-csv-product-import/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce-xml-csv-product-import/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce-xml-csv-product-import/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce-xml-csv-product-import/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce-xml-csv-product-import/reviews/)

 * 4 replies
 * 2 participants
 * Last reply from: [WP All Import](https://wordpress.org/support/users/wpallimport/)
 * Last activity: [8 years, 2 months ago](https://wordpress.org/support/topic/database-optimization-2/#post-10109161)
 * Status: resolved