vinc1402 Posted November 19, 2019 Share Posted November 19, 2019 (edited) https://support.reliablesite.net/kb/a280/optimizing-the-whmcs-database-for-performance.aspx ALTER TABLE tblproductconfigoptionssub DROP INDEX configid, ADD INDEX configid (configid ASC, hidden ASC, sortorder ASC, id ASC); ALTER TABLE tblpricing ADD INDEX relid (relid ASC, type ASC, currency ASC); ALTER TABLE tblproductconfiglinks ADD UNIQUE INDEX pid_gid (pid ASC, gid ASC); ALTER TABLE tblproductconfigoptions DROP INDEX productid, ADD INDEX productid (gid ASC, hidden ASC); I just found this article, would it be a safe operation to do? Edited November 19, 2019 by vinc1402 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.