SeanP Posted April 7 Share Posted April 7 (edited) I have a lot of configurable options for some of my products (needed for a custom server module). This makes the load time of these products slow on the web site. It can take 5-7 seconds for the products to even display on the page, once you click on the product group. Is there anyway to increase the speed for these products (database indexes, etc)? I have tried adding CPU and memory to my server, but it doesn't seem to help. I have even tried performance tweaks for MySQL 8.0 without any luck. I think the way WHMCS accesses products with large sets of configurable options, is not very efficient. Edited April 7 by SeanP 0 Quote Link to comment Share on other sites More sharing options...
Azhar Patel Posted April 8 Share Posted April 8 @SeanP Approx. how many custom fields do you have ? 0 Quote Link to comment Share on other sites More sharing options...
SeanP Posted April 9 Author Share Posted April 9 22 hours ago, Azhar Patel said: @SeanP Approx. how many custom fields do you have ? Configurable options, not custom fields. 0 Quote Link to comment Share on other sites More sharing options...
Azhar Patel Posted April 9 Share Posted April 9 Approx. how many Configurable options do you have ? 0 Quote Link to comment Share on other sites More sharing options...
SeanP Posted April 10 Author Share Posted April 10 One on the product groups has 2 products with a combined total of around 1k to 1.5k configurable options. Of course, the majority of these options are not displayed to the client, and are only used internally for a custom module. 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Support Manager WHMCS John Posted April 11 WHMCS Support Manager Share Posted April 11 Hi @SeanP, What's the filename of the page or action upon which you experiencing slow loading exactly? For example is it /admin/configproducts.php , or cart.php? Which version of WHMCS are you running? 0 Quote Link to comment Share on other sites More sharing options...
SeanP Posted April 11 Author Share Posted April 11 25 minutes ago, WHMCS John said: Hi @SeanP, What's the filename of the page or action upon which you experiencing slow loading exactly? For example is it /admin/configproducts.php , or cart.php? Which version of WHMCS are you running? Hi @WHMCS John, It's happening on the client side (cart.php). When you click on the product group on our web site, it is delayed showing the products. The admin side doesn't have any speed issue. 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Support Manager WHMCS John Posted April 11 WHMCS Support Manager Share Posted April 11 Hi @SeanP, We've made improvements in this area in recent years, so please ensure you're running 8.7 and above to benefit from these: CORE-16706 — Add indices for pricing table https://docs.whmcs.com/releases/8-3/8-3-change-log/#830-general-availability CORE-17665 — Improve cart performance with several thousand configurable option values https://docs.whmcs.com/releases/8-7/8-7-change-log/#870-beta-2 0 Quote Link to comment Share on other sites More sharing options...
SeanP Posted Tuesday at 04:35 AM Author Share Posted Tuesday at 04:35 AM Hi @WHMCS John, Thanks for the info! 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.