Slow site performance
Hello,
I have been trying to setup my power store and it has slowly been getting VERY SLOW, to the point where I get this error : "MySQL server has gone away."
Any ideas???
Hello,
I have been trying to setup my power store and it has slowly been getting VERY SLOW, to the point where I get this error : "MySQL server has gone away."
Any ideas???
What version of PowerStore?
Was it an upgrade from PS3? or a new install of PS4?
Try adding an index to the product options table. Open the PS Database in PHPMyAdmin and run the following SQL command:
ALTER TABLE ps4_productoptions ADD INDEX (ProductID)
if it was an upgrade from PS3, then add an index to the proctcategories table to:
ALTER TABLE ps4_productcategories ADD INDEX (ProductID)
This was a fresh install and i tried the command but didn't help. It is still very slow but only after I try to edit the products in admin. Navigating the site otherwise is fine, but as soon as I get into that admin area... nothing works :/
I have created a support ticket so we can look into this issue further.
To view and edit your support ticket, please log into your support history:
supporthistory.php
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.