Title: WordPress database crash
Last modified: March 27, 2023

---

# WordPress database crash

 *  Resolved [ksfx](https://wordpress.org/support/users/ksfx/)
 * (@ksfx)
 * [3 years, 2 months ago](https://wordpress.org/support/topic/wordpress-database-crash/)
 * My webpage overloads database when duplicating products. I am trying to add thousands
   of products and usually my database crashes after about 20 copies. I contacted
   the domain prodiced/host and they told me the crash is due to max_queries_per_hour
   limit that they have. The limit is 36 000 and so i don’t see how 20 products 
   can cross the 36 000 queries limit. 
   Each of the products has 65 variation. Still
   the math tells me I am way below that 36 000 executions. Any help would be appreciated
    -  This topic was modified 3 years, 2 months ago by [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/).
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fwordpress-database-crash%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 1 replies (of 1 total)

 *  Moderator [threadi](https://wordpress.org/support/users/threadi/)
 * (@threadi)
 * [3 years, 2 months ago](https://wordpress.org/support/topic/wordpress-database-crash/#post-16599425)
 * With 20 products, each of which has 65 variants, there are a total of 1300 different
   combinations. WooCommerce must fire several statements for these – among other
   things, query whether the product already exists, whether the linked attributes
   exist and if so, read them out. Assuming WooCommerce sends 10 statements per 
   combination, you immediately have 13,000 SQL statements.
 * By the way, your database will not crash. Your project is subject to a restriction
   by your hoster. WordPress itself cannot change this.
 * I see several possibilities for your project:
   a) You look for a completely different
   hoster without such a restriction.b) Uninstall all plugins except WooCommerce.
   Maybe some plugins interfere with the import and create additional statements.
   c) You could copy the project to you locally, do the import there (without such
   a restriction) and then upload the result to the hosting. You can do such an 
   export and import e.g. with [https://wordpress.org/plugins/updraftplus/](https://wordpress.org/plugins/updraftplus/)
   or [https://wordpress.org/plugins/all-in-one-wp-migration/](https://wordpress.org/plugins/all-in-one-wp-migration/).
   d) You use the WP CLI for the import. This will not avoid the database limitation,
   but will run without other timeouts.
 * Of course you can also describe your plan in the WooCommerce support forum. Maybe
   someone there has an idea for this very WooCommerce specific problem: [https://wordpress.org/support/plugin/woocommerce/](https://wordpress.org/support/plugin/woocommerce/)

Viewing 1 replies (of 1 total)

The topic ‘WordPress database crash’ is closed to new replies.

## Tags

 * [Crash](https://wordpress.org/support/topic-tag/crash/)
 * [database](https://wordpress.org/support/topic-tag/database/)
 * [variable product](https://wordpress.org/support/topic-tag/variable-product/)

 * In: [Everything else WordPress](https://wordpress.org/support/forum/miscellaneous/)
 * 1 reply
 * 2 participants
 * Last reply from: [threadi](https://wordpress.org/support/users/threadi/)
 * Last activity: [3 years, 2 months ago](https://wordpress.org/support/topic/wordpress-database-crash/#post-16599425)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics