Optimization Of SugarCRM

[ashokinsugar]

Hi Friends,

I have faced lots of problem due to slow performance of SugarCRM Instance due to many resaons.
To Overcome that, I have gather few information and acumulated togeter so that others can get some relief.

This is just few steps and can be achieved in more greater way.

The configuration points are as below:
1. In Config.php include the below line :

a. ‘hide_subpanels_on_login’ => true ,
b. ‘verify_client_ip’ => false ,
c. ‘disable_count_query’ => true ,
d. ‘log_level’ => ‘fatal’,
e. ‘log_memory_usage’ => false,
f. ‘save_query’ => ‘populate_only’,

2. In php.ini configuration

a. zlib.output_compression = 1 //by default it is off

3. Run the below query to optimize the tables.

OPTIMIZE TABLE <tablename>

4. Sugarcrm : Do not keep the SugarCRM Instance in debug mode.

5. In mysql my.ini changes as below:
query_cache_size=SIZE
//The amount of memory (SIZE) allocated for caching query results.The default value is 0, which disables the query cache.

On Search I found more things could be done to optimze SugarCRM even more with careful are as below :

1. ALTER TABLE t1 ENGINE=InnoDB;
2. ‘hide_subpanels’ => true , //in config to hide all the subpanes
3. ‘disable_vcr’ => true ,
4. Set index to tables .
5. query_cache_type=OPTION

Set the query cache type.
Possible options are as follows:

0 : Don’t cache results in or retrieve results from the query cache.
1 : Cache all query results except for those that begin with SELECT S_NO_CACHE.
2 : Cache results only for queries that begin with SELECT SQL_CACHE

Do reply for any query..........................Have Fun

[eggsurplus]

Good stuff!