M Running with suitecrm 7.1.1 i have did some customization and also have added some custom modules , for report purpose i have created php script and setup the cron to run that ,
My question is how we can improve performance i have follow this things
One option is to install APC. This provides opcode caching for PHP which will provide slight performance increases for PHP. It’s also used by SuiteCRM if it is available so should improve performance. If the performance issue is somewhere else (say database contention) then it may have little effect.
APC can be installed under Ubuntu with:
apt-get install php-apc
Thanks,
So do i need to install APC i am running with linux how we can use it can some one guide me on this
You can use PHP APC’s apc_cache_info() to check what data is being cached by the APC. If you get info form apc_cache_info then APC is in use. You can get info on how to use it in http://php.net/manual/en/function.apc-cache-info.php
Yes you can set up indexes the database or use database partitioning. That can increase the query performance on result fetching. For this you do not need to change Suite’s queries, they are well built (and I advice you against it unless you really know what you are doing !). Also, if you’re optimizing the db, you’ll need to keep monitoring the database performance.
For things to keep in mind while using APC, you would really need to study it’s behavior after implementing it. You can try that in your test environment with SuiteCRM with a heavily loaded db.
SuiteCRM is compatible with both APC and memcache.
I would advise you to read and learn more on APC and memcache or memcached and then you will understand why you need to have it installed on the machine as well as how to properly configure it so it doesn’t break.
There is no simple configuration that works for all and you should not expect to get one.