Side Filter Bar Performance

Author	« Topic »
dnyman New Member Australia 86 Posts Pre-sales questions only (More Details...)	Posted - 01/26/2018 : 20:42:27 We are running ECT 6.7.3. Our products.php pages utilise the side filter bar, and some pages take a long time to load (9 or more seconds for some with a lot of attributes assigned). I found the following on the forum, which I think applies to us: https://www.ecommercetemplates.com/support/topic.asp?TOPIC_ID=106871 However, I'm not quite sure what action I should take. The link to the fix Vince placed (last post in this topic) is also broken. Could someone please give me specific actions to remedy this problem with my database? Thanks, Dave.
Andy ECT Moderator 95440 Posts	Posted - 01/27/2018 : 00:25:24 Hi Dave The database utility is now included in the admin under the Store Admin drop down. Can you check the collation there and see if you too have a mix in the columns like the user in the thread you linked to? Andy Please feel free to review / rate our software
dnyman New Member Australia 86 Posts Pre-sales questions only (More Details...)	Posted - 01/27/2018 : 02:32:04 Hi Andy. Do you mean the one labelled “Set database collation”? Can I run this without fear of destroying the database? Dave.
Andy ECT Moderator 95440 Posts	Posted - 01/27/2018 : 03:15:42 That's the one. If you click on the GO button next to Set database collation, you should see a list of collation for tables and columns - are these all set the same? Andy Please feel free to review / rate our software
dnyman New Member Australia 86 Posts Pre-sales questions only (More Details...)	Posted - 01/27/2018 : 18:51:50 Hi Andy, Did that, and it appears that NOT all tables and columns have the same collation. The majority (I think) have latin1_swedish_ci, while many others have utf8_general_ci. multisearchcriteria is as follows: multisections utf8_general_ci pID utf8_general_ci searchcriteria is as follows: searchcriteria utf8_general_ci scWorkingName utf8_general_ci scName utf8_general_ci scName2 utf8_general_ci scName3 utf8_general_ci scLogo utf8_general_ci scURL utf8_general_ci scURL2 utf8_general_ci scURL3 utf8_general_ci scEmail utf8_general_ci searchcriteriagroup utf8_general_ci scgTitle utf8_general_ci scgTitle2 utf8_general_ci scgTitle3 utf8_general_ci scgWorkingName utf8_general_ci What would you suggest I do? Dave.
Sinbad ECT Moderator USA 65937 Posts	Posted - 01/27/2018 : 20:06:27 Hi Dave, have a look at the post here by Vince https://www.ecommercetemplates.com/support/topic.asp?TOPIC_ID=108339 Winners never quit, quitters never win CSS and Responsive Designs User Manual for Ecommerce Templates
Phil ECT Moderator United Kingdom 7715 Posts	Posted - 01/28/2018 : 04:24:13 Hi Dave, Looking at you post I'm 99.9% sure the default collation will be utf8_general_ci due to the fact that when you run updatestore.php and new tables are added the script uses the default collation that's set on the server. The table multisearchcriteria is one of the new tables added with the updater. So I would set them all to utf8_general_ci then any further tables added in future updates will not cause any collation issues. * Database Migrations and Conversions* * ASP to PHP Cart Conversions* *Contact Us* *Buy The PHP Capture Card Plugin* Rate Our Services/View Our Feedback
dnyman New Member Australia 86 Posts Pre-sales questions only (More Details...)	Posted - 01/28/2018 : 19:52:42 Hey guys. You fellas are absolute gems. I changed to database collation to utf8_general_ci, and almost everything is running a factor of 10 faster! Thanks for all the help. Cheers, Dave.
	« Topic »