Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

How to Improve your vTiger CRM Performance

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

Do You Need More Information ?

For any further information / query regarding Technology, please email us at [email protected]
OR call us on +1 630 861 8263, Alternately you can request for information by filling up Contact Us

This post first appeared on CRMTiger | VTiger Customization, please read the originial post: here

Share the post

How to Improve your vTiger CRM Performance


Subscribe to Crmtiger | Vtiger Customization

Get updates delivered right to your inbox!

Thank you for your subscription