Difference between revisions of "Maximising Performance"

From WHMCS Documentation

(Created page with '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 databas…')
 
Line 1: Line 1:
 
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...
 
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 Full Client Dropdown Menus''' - This setting is found in Setup > General Settings > Other and works by replacing the dropdown menus on various pages listing clients with a simple text input field which prevents the system having to loop through and output the HTML for thousands of clients when a page is loaded
+
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 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:
  
3. '''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;
  
  $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.

Revision as of 17:49, 4 May 2017

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.