Database Optimization

  • Resolved vurdalak

    (@vurdalak)


    6 years, 8 months ago

    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

    (@wpallimport)

    Hey @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

    (@vurdalak)

    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

    (@vurdalak)

    Any suggestion what i can do incorrect?

    Plugin Author WP All Import

    (@wpallimport)

    Hi @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 https://www.wpallimport.com/debug/ and open a ticket at https://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.