Are you facing Performance problems with your vTiger CRM? I’m sure you’re or you will when data in your CRM rise to certain records.

CRMTiger team working with vTiger since more than a decade so we keep receiving complaints from customer that,

• My CRM is slow.
• We’ve problem with saving records.
• It’s frustrating when we open any record it TOO Slow..You too.. Right ?

Considering All these issues, We tried to create the list and just wanted to share with you so it will be helpful to you.

We divide performance in three main categories:

• Performance Improvement at System Level(OS Level).
• Performance Improvement steps for CRM.
• Performance Improvement steps for Database.

1. Performance Improvement at System Level(OS Level):

Php.ini variable setting

• a. file_uploads = on
• b. upload_max_filesize = 5M or higher
• c. display_errors = on
• d. sql.safe_mode = off
• e. max_input_vars = 10000
• f. max_execution_time = 600
• g. memory_limit = 512M or higher
• h. post_max_size = 128M
• i. max_input_time = 120
• j. register_globals = Off
• k. output_buffering= On
• l. error_reporting = E_WARNING & ~E_NOTICE
• m. allow_call_time_reference = On
• n. log_errors = Off
• o. short_open_tag= On
• p. suhosin.simulation = on
• q. extension=php_gd2.dll
• r. extension=php_imap.dll
• s. extension=php_mysql.dll
• t. extension=php_mysqli.dll
• u. extension=php_mbstring.dll

2. Steps to update CRM for Improvement:

1. Deactivate modules you don’t use:

• a. GOTO CRMSettings -> Module manager > Uncheck Module from Module List which you’re not using it.

2. Configure your sharing permissions correctly:

• Adding unnecessary groups, sharing privileges and exceptions contribute to making more complex code execution to generation bigger SQL which takes longer to retrieve the information needed.

3. Speed Up Your Listview Load Times:

• i. If you have a large Vtiger database, you may experience slow loading time while in list views than can you please do below thing.
• ii. changing the list view sorting default from ‘true’ to ‘false’.
• ii. changing the list view sorting default from ‘true’ to ‘false’.
• iii. There is a setting in config.performance.php, Change ‘LISTVIEW_DEFAULT_SORTING’ from ‘true’ to ‘false’.

3. Performance Improvement Steps for Database:

• Find Long Running Query and Implement Indexing.
  • Find Long run query and Optimize it using Indexing.
    • Can you login on mysql server and then after run below command on CMD.
      • show processlist;
    • Can you please use below command for indexing particular table with column.
      • CREATE INDEX [index name] ON [table name]([column name]);
  • Auto Set Indexing on All Tables using PHP script

Create PHP page and add following:

• To enable the slow query log, type the following command at the mysql> prompt
  • iv. SET GLOBAL slow_query_log = ‘ON’;
  • v. SET GLOBAL long_query_time = X;

• If you use UTF-8 charset then we recommend check:
  • ‘DB_DEFAULT_CHARSET_UTF8’ => true

• MySQL setting
  • query_cache_size=100M
  • innodb_buffer_pool_size=200M
  • innodb_additional_mem_pool = 20M
  • join_buffer_size = 8M
  • tmp_table_size = 64M
  • sort_buffer_size = 8M
  • query_cache_limit =2M
  • sql_mode = ‘’;
  • default-storage-engine = InnoDB
  • collation-server = utf8_general_ci
  • character-set-server = utf8

Hope you found this blog useful.

Please contact us on [email protected] if you needed further help from us.

Let us know if you needs more information on this