This is the SQL I have often used to fix issues with the variations tab and subsequent pages loading slowly. Please back up the database sufficiently.
Run the first SQL step:
Code: Select all
DELETE FROM isc_product_variation_combinations WHERE vcvariationid IN (SELECT `variationid` FROM `isc_product_variations` WHERE `variationid` NOT IN (SELECT DISTINCT prodvariationid FROM isc_products))
Code: Select all
DELETE FROM isc_product_variation_options WHERE vovariationid IN (SELECT `variationid` FROM `isc_product_variations` WHERE `variationid` NOT IN (SELECT DISTINCT prodvariationid FROM isc_products))
Code: Select all
DELETE FROM `isc_product_variations` WHERE `variationid` NOT IN (SELECT DISTINCT prodvariationid FROM isc_products)
What this shall do is clear all unused variations and combinations, which I will explain briefly.
You initially had Product X which had variation options of A, B, or C.
Product Y also uses the same variation 'set'.
Product X is removed from your website, or you remove the variations as these are no longer required.
In the isc_product_variations_options and isc_product_variation_combinations tables, deleting Product X or unchecking 'This product will use variations', the data is not cleared from these tables and so becomes redundant. All the data of these tables is searched to show the appropriate variations for the product you are editing. Obviously the more redundant data there is, the slower this will load.
If this still does not help, I would advise you to contact your host as there may be limits on the database or php memory limits. A quick and easy way to test this is to go to Products > Export Products and use the Default export template and select all the available options (in particular, the variation options) to export. If the export gives a Memory Limit error and so does not create the CSV as expected, the server memory is probably the problem. Ultimately the real problem is poor software in this department from Interspire, but the variations (especially to Export) do require a hell of a lot of memory.
Hopefully this solves issues for some folks
![Smile :)](./images/smilies/icon_e_smile.gif)