Maximising Performance

If you grow to have a large client base then you might start to find page loads begin to slow down. This is to be expected, because the more data you have, the larger the database becomes, and so calculating and looping through the data will naturally take longer. However there are some things you can do to help keep things fast...

1. Disable Sidebar Stats - The sidebar stats in WHMCS are calculated on every page load. Normally this is no problem but when you get big, it can start to take longer. So to avoid that, simply disable the "Sidebar Statistics" admin role group permission in Setup > Administrator Roles for any roles you use and then the stats won't be loaded. And all the stats can still be obtained via the actual reports section anyway when you need them.

2. Disable Ticket Counts - When you have a lot of tickets, calculating the number of tickets per status to display each time you open a ticket can slow things down. So to avoid that you can disable the ticket counts by adding the following line to your WHMCS configuration.php file:

$disable_admin_ticket_page_counts = true;

3. Logging - In WHMCS, there are quite a few things you can enable that will log things such as SQL errors, Hooks loading, Module commands, etc. You can find these under Setup >> General Settings >> Other Tab :: SQL Error Reporting | Hooks Debug, Utilities >> Logs >> Module Debug Log. Ensure that these are disabled when not needed for debugging errors that may occur as they can/will increase the database size exponentially.

4. Hooks/Addons - Third party customizations, while a great addition to functionality, can at times slow performance of WHMCS. Ensure that any customization that you are using is up to date and functionality wise, works with the version of WHMCS you are running.