Slow Products Page after adding sidebar filters

Author	« Topic »
wellsuited New Member 95 Posts	Posted - 10/20/2023 : 08:37:33 When I added the sidebar filter to the products page the page went from loading in less than a second to over 10 seconds. It doesn't matter if the category has one product or 100 it still takes a long time to load. I tried installing on a dedicated server with more RAM but that did not change the speed for this page. Are there any settings to speed this function up?
Vince Administrator 42750 Posts	Posted - 10/21/2023 : 05:28:10 Hi Wellsuited There aren't functions to speed it up as normally to tell the truth, speed isn't an issue. Have you got a lot of product attributes defined maybe? And have you been using the top filter before turning on the side filter and if so was that a problem? And have you got the latest version installed (which is normally a good first step.) Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
dbdave ECT Moderator USA 10406 Posts	Posted - 10/21/2023 : 09:07:06 Hi, in addition to the questions Vince raised, it may be helpful if we knew how many products you are loading per page. If it's unusually high, and you have a huge amount of attributes assigned, if may be helpful to reduce the products per page if that's set to a high number. David
wellsuited New Member 95 Posts	Posted - 10/23/2023 : 11:03:45 Yes, lots of products and product attributes. The top filter has the same time loads. Limiting the page results has not change on the page load time. I am loading 10 per page. Is there a way to flush the products and have the sidebar load after? Or anything like that to speed up the page.
Vince Administrator 42750 Posts	Posted - 10/23/2023 : 23:44:34 Is there any way you can combine attributes or remove any unwanted attributes? Also, are you able to get a dump of the database via phpMyAdmin so that I can try your setup here? Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
wellsuited New Member 95 Posts	Posted - 10/30/2023 : 05:16:47 Vince, I can send you a dump, do you also want the products table?
Vince Administrator 42750 Posts	Posted - 10/30/2023 : 12:01:48 Yes, the products table would be good too. My email address is vince AT ecommercetemplates DOT com. Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
	« Topic »