Large Number Of Variations Slow

  • Resolved jhanson107

    (@jhanson107)


    4 years, 3 months ago

    I am struggling with performance for products with a large number of variations. I have tried W3 Total Cache and https://www.wpintense.com/product/scalability-pro/ with no real luck.

    In this particular case I have a product with 562 variations. I have used Extra Product Options with success for other products but unfortunately I am dealing with a product that doesn’t have fixed addon prices so the only real option is a variable product.

    It looks like when the page loads it has to load all variations which ends up taking almost 15 seconds to finish loading. Ideally it would only query the database after the user selects all required options. Has anyone had success with performance and large product variations?

    Here is a sample of a problem page:
    https://deltakon.com/product/additel-adt-681-digital-pressure-gauges/

    This is the slow query that I believe is causing the issue:

    SELECT post_id, meta_key, meta_value
FROM wp_z3in8a5_postmeta
WHERE post_id IN (33386,33271,33272,33273,33274,33275,33276,33277,33278,33279,33280,33281,33282,33283,33284,33285,33286,33287,33288,33289,33290,33291,33292,33293,33294,33295,33296,33297,33298,33299,33300,33301,33302,33303,33304,33305,33306,33307,33308,33309,33310,33311,33312,33313,33314,33315,33316,33317,33318,33319,33320,33321,33322,33323,33324,33325,33326,33327,33328,33329,33330,33331,33332,33333,33334,33335,33336,33337,33338,33339,33340,33341,33342,33343,33344,33345,33346,33347,33348,33349,33350,33351,33352,33353,33354,33355,33356,33357,33358,33359,33360,33361,33362,33363,33364,33365,33366,33367,33368,33369,33370,33371,33372,33373,33374,33375,33376,33377,33378,33379,33380,33381,33382,33383,33384,33385,33387,33388,33389,33390,33391,33392,33393,33394,33395,33396,33397,33398,33399,33400,33401,33402,33403,33404,33405,33406,33407,33408,33409,33410,33411,33412,33413,33414,33415,33416,33417,33418,33419,33420,33421,33422,33423,33424,33425,33426,33427,33428,33429,33430,33431,33432,33433,33434,33435,33436,33437,33438,33439,33440,33441,33442,33443,33444,33445,33446,33447,33448,33449,33450,33451,33452,33453,33454,33455,33456,33457,33458,33459,33460,33461,33462,33463,33464,33465,33466,33467,33468,33469,33470,33471,33472,33473,33474,33475,33476,33477,33478,33479,33480,33481,33482,33483,33484,33485,33486,33487,33488,33489,33490,33491,33492,33493,33494,33495,33496,33497,33498,33499,33500,33501,33502,33503,33504,33505,33506,33507,33508,33509,33510,33511,33512,33513,33514,33515,33516,33517,33518,33519,33520,33521,33522,33523,33524,33525,33526,33527,33528,33529,33530,33531,33532,33533,33534,33535,33536,33537,33538,33539,33540,33541,33542,33543,33544,33545,33546,33547,33548,33549,33550,33551,33552,33553,33554,33555,33556,33557,33558,33559,33560,33561,33562,33563,33564,33565,33566,33567,33568,33569,33570,33571,33572,33573,33574,33575,33576,33577,33578,33579,33580,33581,33582,33583,33584,33585,33586,33587,33588,33589,33590,33591,33592,33593,33594,33595,33596,33597,33598,33599,33600,33601,33602,33603,33604,33605,33606,33607,33608,33609,33610,33611,33612,33613,33614,33615,33616,33617,33618,33619,33620,33621,33622,33623,33624,33625,33626,33627,33628,33629,33630,33631,33632,33633,33634,33635,33636,33637,33638,33639,33640,33641,33642,33643,33644,33645,33646,33647,33648,33649,33650,33651,33652,33653,33654,33655,33656,33657,33658,33659,33660,33661,33662,33663,33664,33665,33666,33667,33668,33669,33670,33671,33672,33673,33674,33675,33676,33677,33678,33679,33680,33681,33682,33683,33684,33685,33686,33687,33688,33689,33690,33691,33692,33693,33694,33695,33696,33697,33698,33699,33700,33701,33702,33703,33704,33705,33706,33707,33708,33709,33710,33711,33712,33713,33714,33715,33716,33717,33718,33719,33720,33721,33722,33723,33724,33725,33726,33727,33728,33729,33730,33731,33732,33733,33734,33735,33736,33737,33738,33739,33740,33741,33742,33743,33744,33745,33746,33747,33748,33749,33750,33751,33752,33753,33754,33755,33756,33757,33758,33759,33760,33761,33762,33763,33764,33765,33766,33767,33768,33769,33770,33771,33772,33773,33774,33775,33776,33777,33778,33779,33780,33781,33782,33783,33784,33785,33786,33787,33788,33789,33790,33791,33792,33793,33794,33795,33796,33797,33798,33799,33800,33801,33802,33803,33804,33805,33806,33807,33808,33809,33810,33811,33812,33813,33814,33815,33816,33817,33818,33819,33820,33821,33822,33823,33824,33825,33826,33827,33828,33829,33830,33831,33832)
ORDER BY meta_id ASC

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support RK a11n

    (@riaanknoetze)

    Hi there,

    The first considering is to make absolutely sure that a variable product of that size is needed: Using 562 variations makes for a difficult UI as the user would need to sift through a lot of options. Unfortunately, I was unable to access that page to see whether the UI could be improved as I’m getting the following:


    Link to image: https://d.pr/i/HUhDXv

    Thread Starter jhanson107

    (@jhanson107)

    Hello RK,

    Thank you for trying to take a look. Currently we use SiteLock which only allows US visitors at the moment. I can white list your country if your comfortable sharing that.

    One thing I found out during troubleshooting is one of the plugins I was using called TM Extra Product Options was causing the page to load very slowly. Once I disabled that the page loads fine but unfortunately ajax on the options no longer works which does make option selection difficult because I need the corresponding attribute drop downs to refresh after each selection is made.

    The large number of variations for this particular product is common because it’s for a pressure gauge that comes in a wide array of configurations:

    
<a href="//imgur.com/a/uYSvLoS"></a></blockquote><script async src="//s.imgur.com/min/embed.js" charset="utf-8"></script>

    https://www.additel.com//download/datasheet/681_digital_pressure_gauge.pdf

    Perhaps there is a better way of configuring a product like this? I can’t use product options because each configuration has a different price and option add on costs are not equal (which is a bummer).

    • This reply was modified 4 years, 3 months ago by Yui.
    • This reply was modified 4 years, 3 months ago by Yui. Reason: please use CODE button for proper formatting
    Plugin Support mouli a11n

    (@mouli)

    @jhanson107
    I suggest that you consider https://woocommerce.com/products/composite-products/ which is geared to selling items that are made up of multiple parts.
    You might be able to use it to walk the customer through the options as is they were components.
    If you want to try it, WooCommerce.com have a 30-day refund policy. If the product doesn’t work the way you need or you think another product would work better, we are more than happy to provide a full refund.
    You can read more about our refund policy on our website here: https://woocommerce.com/refund-policy/

    I hope that helps you to figure it out.
    Feel free to get back to us if you have further questions.

    @jhanson107 we haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread. Cheers!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Large Number Of Variations Slow’ is closed to new replies.