![\"\"](\"http:\/\/crmtiger.com\/blog\/wp-content\/uploads\/2017\/02\/check.png\")
My CRM is slow.<\/li>\n We\u2019ve got problems saving records.<\/li>\n It\u2019s frustrating when we open any record too slowly. You too, right?<\/li>\n<\/ul>\nConsidering all these issues, we tried to create the list and just wanted to share it with you so it would be helpful to you.<\/p>\n
We divide performance into three main categories:<\/span><\/h3>\n\n- Performance Improvement at System Level (OS Level).<\/li>\n
- Performance improvement steps for CRM.<\/li>\n
- \u00a0Performance improvement steps for the database.<\/li>\n<\/ul>\n
1. Performance Improvement at System Level(OS Level):<\/span><\/strong><\/h3>\nPhp.ini variable setting <\/span><\/p>\n\n- a. file_uploads = on<\/li>\n
- b. upload_max_filesize = 5M or higher<\/li>\n
- c. display_errors = on<\/li>\n
- d. sql.safe_mode = off<\/li>\n
- e. max_input_vars = 10000<\/li>\n
- f. max_execution_time = 600<\/li>\n
- g. memory_limit = 512M or higher<\/li>\n
- h. post_max_size = 128M<\/li>\n
- i. max_input_time = 120<\/li>\n
- j. register_globals = Off<\/li>\n
- k. output_buffering= On<\/li>\n
- l. error_reporting = E_WARNING & ~E_NOTICE<\/li>\n
- m. allow_call_time_reference = On<\/li>\n
- n. log_errors = Off<\/li>\n
- o. short_open_tag= On<\/li>\n
- p. suhosin.simulation = on<\/li>\n
- q. extension=php_gd2.dll<\/li>\n
- r. extension=php_imap.dll<\/li>\n
- s. extension=php_mysql.dll<\/li>\n
- t. extension=php_mysqli.dll<\/li>\n
- u. extension=php_mbstring.dll<\/li>\n<\/ul>\n
2. Steps to update CRM for improvement:<\/span><\/strong><\/h3>\n1. Deactivate modules you don\u2019t use:<\/strong><\/span><\/p>\n\n- i. GOTO\u00a0CRMSettings -> Module Manager > Uncheck Module<\/strong> from the Module List if you\u2019re not using it.<\/li>\n<\/ul>\n
2. Configure your sharing permissions correctly:<\/strong><\/span><\/p>\n\n- Adding unnecessary groups, sharing privileges, and exceptions contribute to more complex code execution and the generation of bigger SQL, which takes longer to retrieve the information needed.<\/li>\n<\/ul>\n
3. Speed Up Your Listview Load Times:<\/strong><\/span><\/p>\n\n- ii. If you have a large Vtiger database, you may experience slow loading times while in list views. Can you please do the below thing?<\/li>\n
- iii. changing the list view sorting default from \u2018true\u2019 to \u2018false\u2019.<\/li>\n
- iv. There is a setting in config.performance.php: change \u2018LISTVIEW_DEFAULT_SORTING\u2019 from \u2018true\u2019 to \u2018false\u2019.<\/li>\n<\/ul>\n
3. Performance Improvement Steps for Database:<\/span><\/strong><\/h3>\n\n- Find a long-running query and implement indexing.<\/strong>\n
\n- Find a long-run query and optimize it using indexing.\n
\n- Can you login to the MySQL server and then run the below command on CMD?\n
\n- show processlist;<\/li>\n<\/ul>\n<\/li>\n
- Can you please use the below command for indexing a particular table with a column?\n
\n- CREATE INDEX [index name] ON [table name] ([column name]);<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n
- Auto-set indexing on all tables using a PHP script<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
![\"img\"](\"https:\/\/crmtiger.com\/blog\/wp-content\/uploads\/2020\/11\/CRMTiger.jpg\")
<\/a>
\nCreate PHP page and add following:<\/strong><\/p>\n![\"\"](\"https:\/\/crmtiger.com\/blog\/wp-content\/uploads\/2020\/10\/code.png\")
<\/p>\n
\n- To enable the slow query log, type the following command at the mysql> prompt<\/strong>\n
\n- v. SET GLOBAL slow_query_log = ‘ON’;<\/li>\n
- vi. SET GLOBAL long_query_time = X;<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
\n- If you use UTF-8 charset then we recommend check:<\/strong>\n
\n- \u2018DB_DEFAULT_CHARSET_UTF8\u2019 => true<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
\n- MySQL setting<\/strong>\n
\n- query_cache_size=100M<\/li>\n
- innodb_buffer_pool_size=200M<\/li>\n
- innodb_additional_mem_pool = 20M<\/li>\n
- join_buffer_size = 8M<\/li>\n
- tmp_table_size = 64M<\/li>\n
- sort_buffer_size = 8M<\/li>\n
- query_cache_limit =2M<\/li>\n
- sql_mode = \u2018\u2019;<\/li>\n
- default-storage-engine = InnoDB<\/li>\n
- collation-server = utf8_general_ci<\/li>\n
- character-set-server = utf8<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
Hope you found this blog useful.<\/span><\/p>\nPlease contact us at<\/span>\u00a0info@crmtiger.com<\/a> if you needed further help from us.<\/span><\/p>\nLet us know if you needs more information on this
\n<\/a><\/p>\n\nDo you need more information ?<\/strong><\/p>\nFor any further information \/ query regarding Technology, please email us at info@crmtiger.com<\/a>
\nOR call us at\u00a0+1 630 861 8263<\/span>, Alternately you can request for information by filling up Contact Us<\/a>\u00a0form.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"Are you facing performance problems with your vTiger CRM? I\u2019m sure you\u2019re or you will when data in your CRM rises to certain records.<\/p>\n","protected":false},"author":2,"featured_media":2226,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2228","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-knowledge"],"_links":{"self":[{"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/posts\/2228","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/comments?post=2228"}],"version-history":[{"count":13,"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/posts\/2228\/revisions"}],"predecessor-version":[{"id":3707,"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/posts\/2228\/revisions\/3707"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/media\/2226"}],"wp:attachment":[{"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/media?parent=2228"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/categories?post=2228"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/tags?post=2228"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Performance Improvement at System Level (OS Level).<\/li>\n Performance improvement steps for CRM.<\/li>\n\u00a0Performance improvement steps for the database.<\/li>\n<\/ul>\n1. Performance Improvement at System Level(OS Level):<\/span><\/strong><\/h3>\nPhp.ini variable setting <\/span><\/p>\n\n- a. file_uploads = on<\/li>\n
- b. upload_max_filesize = 5M or higher<\/li>\n
- c. display_errors = on<\/li>\n
- d. sql.safe_mode = off<\/li>\n
- e. max_input_vars = 10000<\/li>\n
- f. max_execution_time = 600<\/li>\n
- g. memory_limit = 512M or higher<\/li>\n
- h. post_max_size = 128M<\/li>\n
- i. max_input_time = 120<\/li>\n
- j. register_globals = Off<\/li>\n
- k. output_buffering= On<\/li>\n
- l. error_reporting = E_WARNING & ~E_NOTICE<\/li>\n
- m. allow_call_time_reference = On<\/li>\n
- n. log_errors = Off<\/li>\n
- o. short_open_tag= On<\/li>\n
- p. suhosin.simulation = on<\/li>\n
- q. extension=php_gd2.dll<\/li>\n
- r. extension=php_imap.dll<\/li>\n
- s. extension=php_mysql.dll<\/li>\n
- t. extension=php_mysqli.dll<\/li>\n
- u. extension=php_mbstring.dll<\/li>\n<\/ul>\n
2. Steps to update CRM for improvement:<\/span><\/strong><\/h3>\n1. Deactivate modules you don\u2019t use:<\/strong><\/span><\/p>\n\n- i. GOTO\u00a0CRMSettings -> Module Manager > Uncheck Module<\/strong> from the Module List if you\u2019re not using it.<\/li>\n<\/ul>\n
2. Configure your sharing permissions correctly:<\/strong><\/span><\/p>\n\n- Adding unnecessary groups, sharing privileges, and exceptions contribute to more complex code execution and the generation of bigger SQL, which takes longer to retrieve the information needed.<\/li>\n<\/ul>\n
3. Speed Up Your Listview Load Times:<\/strong><\/span><\/p>\n\n- ii. If you have a large Vtiger database, you may experience slow loading times while in list views. Can you please do the below thing?<\/li>\n
- iii. changing the list view sorting default from \u2018true\u2019 to \u2018false\u2019.<\/li>\n
- iv. There is a setting in config.performance.php: change \u2018LISTVIEW_DEFAULT_SORTING\u2019 from \u2018true\u2019 to \u2018false\u2019.<\/li>\n<\/ul>\n
3. Performance Improvement Steps for Database:<\/span><\/strong><\/h3>\n\n- Find a long-running query and implement indexing.<\/strong>\n
\n- Find a long-run query and optimize it using indexing.\n
\n- Can you login to the MySQL server and then run the below command on CMD?\n
\n- show processlist;<\/li>\n<\/ul>\n<\/li>\n
- Can you please use the below command for indexing a particular table with a column?\n
\n- CREATE INDEX [index name] ON [table name] ([column name]);<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n
- Auto-set indexing on all tables using a PHP script<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
<\/a>
\nCreate PHP page and add following:<\/strong><\/p>\n<\/p>\n
\n- To enable the slow query log, type the following command at the mysql> prompt<\/strong>\n
\n- v. SET GLOBAL slow_query_log = ‘ON’;<\/li>\n
- vi. SET GLOBAL long_query_time = X;<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
\n- If you use UTF-8 charset then we recommend check:<\/strong>\n
\n- \u2018DB_DEFAULT_CHARSET_UTF8\u2019 => true<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
\n- MySQL setting<\/strong>\n
\n- query_cache_size=100M<\/li>\n
- innodb_buffer_pool_size=200M<\/li>\n
- innodb_additional_mem_pool = 20M<\/li>\n
- join_buffer_size = 8M<\/li>\n
- tmp_table_size = 64M<\/li>\n
- sort_buffer_size = 8M<\/li>\n
- query_cache_limit =2M<\/li>\n
- sql_mode = \u2018\u2019;<\/li>\n
- default-storage-engine = InnoDB<\/li>\n
- collation-server = utf8_general_ci<\/li>\n
- character-set-server = utf8<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
Hope you found this blog useful.<\/span><\/p>\nPlease contact us at<\/span>\u00a0info@crmtiger.com<\/a> if you needed further help from us.<\/span><\/p>\nLet us know if you needs more information on this
\n<\/a><\/p>\n\nDo you need more information ?<\/strong><\/p>\nFor any further information \/ query regarding Technology, please email us at info@crmtiger.com<\/a>
\nOR call us at\u00a0+1 630 861 8263<\/span>, Alternately you can request for information by filling up Contact Us<\/a>\u00a0form.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"Are you facing performance problems with your vTiger CRM? I\u2019m sure you\u2019re or you will when data in your CRM rises to certain records.<\/p>\n","protected":false},"author":2,"featured_media":2226,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2228","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-knowledge"],"_links":{"self":[{"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/posts\/2228","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/comments?post=2228"}],"version-history":[{"count":13,"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/posts\/2228\/revisions"}],"predecessor-version":[{"id":3707,"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/posts\/2228\/revisions\/3707"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/media\/2226"}],"wp:attachment":[{"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/media?parent=2228"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/categories?post=2228"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/tags?post=2228"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- \n
- a. file_uploads = on<\/li>\n
- b. upload_max_filesize = 5M or higher<\/li>\n
- c. display_errors = on<\/li>\n
- d. sql.safe_mode = off<\/li>\n
- e. max_input_vars = 10000<\/li>\n
- f. max_execution_time = 600<\/li>\n
- g. memory_limit = 512M or higher<\/li>\n
- h. post_max_size = 128M<\/li>\n
- i. max_input_time = 120<\/li>\n
- j. register_globals = Off<\/li>\n
- k. output_buffering= On<\/li>\n
- l. error_reporting = E_WARNING & ~E_NOTICE<\/li>\n
- m. allow_call_time_reference = On<\/li>\n
- n. log_errors = Off<\/li>\n
- o. short_open_tag= On<\/li>\n
- p. suhosin.simulation = on<\/li>\n
- q. extension=php_gd2.dll<\/li>\n
- r. extension=php_imap.dll<\/li>\n
- s. extension=php_mysql.dll<\/li>\n
- t. extension=php_mysqli.dll<\/li>\n
- u. extension=php_mbstring.dll<\/li>\n<\/ul>\n
2. Steps to update CRM for improvement:<\/span><\/strong><\/h3>\n
1. Deactivate modules you don\u2019t use:<\/strong><\/span><\/p>\n
- \n
- i. GOTO\u00a0CRMSettings -> Module Manager > Uncheck Module<\/strong> from the Module List if you\u2019re not using it.<\/li>\n<\/ul>\n
2. Configure your sharing permissions correctly:<\/strong><\/span><\/p>\n
- \n
- Adding unnecessary groups, sharing privileges, and exceptions contribute to more complex code execution and the generation of bigger SQL, which takes longer to retrieve the information needed.<\/li>\n<\/ul>\n
3. Speed Up Your Listview Load Times:<\/strong><\/span><\/p>\n
- \n
- ii. If you have a large Vtiger database, you may experience slow loading times while in list views. Can you please do the below thing?<\/li>\n
- iii. changing the list view sorting default from \u2018true\u2019 to \u2018false\u2019.<\/li>\n
- iv. There is a setting in config.performance.php: change \u2018LISTVIEW_DEFAULT_SORTING\u2019 from \u2018true\u2019 to \u2018false\u2019.<\/li>\n<\/ul>\n
3. Performance Improvement Steps for Database:<\/span><\/strong><\/h3>\n
- \n
- Find a long-running query and implement indexing.<\/strong>\n
- \n
- Find a long-run query and optimize it using indexing.\n
- \n
- Can you login to the MySQL server and then run the below command on CMD?\n
- \n
- show processlist;<\/li>\n<\/ul>\n<\/li>\n
- Can you please use the below command for indexing a particular table with a column?\n
- \n
- CREATE INDEX [index name] ON [table name] ([column name]);<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n
- Auto-set indexing on all tables using a PHP script<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/a>
\nCreate PHP page and add following:<\/strong><\/p>\n<\/p>\n- \n
- To enable the slow query log, type the following command at the mysql> prompt<\/strong>\n
- \n
- v. SET GLOBAL slow_query_log = ‘ON’;<\/li>\n
- vi. SET GLOBAL long_query_time = X;<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
- \n
- If you use UTF-8 charset then we recommend check:<\/strong>\n
- \n
- \u2018DB_DEFAULT_CHARSET_UTF8\u2019 => true<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
- \n
- MySQL setting<\/strong>\n
- \n
- query_cache_size=100M<\/li>\n
- innodb_buffer_pool_size=200M<\/li>\n
- innodb_additional_mem_pool = 20M<\/li>\n
- join_buffer_size = 8M<\/li>\n
- tmp_table_size = 64M<\/li>\n
- sort_buffer_size = 8M<\/li>\n
- query_cache_limit =2M<\/li>\n
- sql_mode = \u2018\u2019;<\/li>\n
- default-storage-engine = InnoDB<\/li>\n
- collation-server = utf8_general_ci<\/li>\n
- character-set-server = utf8<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
Hope you found this blog useful.<\/span><\/p>\n
Please contact us at<\/span>\u00a0info@crmtiger.com<\/a> if you needed further help from us.<\/span><\/p>\n
Let us know if you needs more information on this
\n<\/a><\/p>\n\nDo you need more information ?<\/strong><\/p>\n
For any further information \/ query regarding Technology, please email us at info@crmtiger.com<\/a>
\nOR call us at\u00a0+1 630 861 8263<\/span>, Alternately you can request for information by filling up Contact Us<\/a>\u00a0form.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"Are you facing performance problems with your vTiger CRM? I\u2019m sure you\u2019re or you will when data in your CRM rises to certain records.<\/p>\n","protected":false},"author":2,"featured_media":2226,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2228","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-knowledge"],"_links":{"self":[{"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/posts\/2228","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/comments?post=2228"}],"version-history":[{"count":13,"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/posts\/2228\/revisions"}],"predecessor-version":[{"id":3707,"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/posts\/2228\/revisions\/3707"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/media\/2226"}],"wp:attachment":[{"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/media?parent=2228"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/categories?post=2228"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/crmtiger.com\/blog\/wp-json\/wp\/v2\/tags?post=2228"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- MySQL setting<\/strong>\n
- \u2018DB_DEFAULT_CHARSET_UTF8\u2019 => true<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
- If you use UTF-8 charset then we recommend check:<\/strong>\n
- To enable the slow query log, type the following command at the mysql> prompt<\/strong>\n
- Can you login to the MySQL server and then run the below command on CMD?\n
- Find a long-run query and optimize it using indexing.\n
- Find a long-running query and implement indexing.<\/strong>\n
- Adding unnecessary groups, sharing privileges, and exceptions contribute to more complex code execution and the generation of bigger SQL, which takes longer to retrieve the information needed.<\/li>\n<\/ul>\n
- i. GOTO\u00a0CRMSettings -> Module Manager > Uncheck Module<\/strong> from the Module List if you\u2019re not using it.<\/li>\n<\/ul>\n