Using suitecrm 7.5.3 with approx database size of 850MB and the average load time for a request to complete is around 8 sec.
Hosted on shared hosting with 1GB ram, php 5.6 with maria db on same server.
Already tried most of the performance tweaks , php, mysql, suite config variables, with no luck (shared hosting has many limitations for php and mysql! )
To debug speed issue, already tried following.
Did a fresh install of suite 7.5.3 and linked the live database to this fresh code, to see if its due to customized code or not but still it was slow, so probably might due to database.
linked to new database (of the fresh install) with existing live code, and seems working speedy!!
Then did a fresh install of suite 7.6.1 and copied all the modules data from live db to this new db one by one and was working very fine, <1 sec, until imported notes and calls data which has huge amount of records and the slow down begun. surprisingly, it is slowing all other modules, i think it is doing join query with all other module records!!
Here is table statistics…
table name = no of records
calls_contacts = ~241,638
calls = ~232,278
notes = ~116,011
accounts, contacts etc too have records around ranging from 30000 to 70000 but works good without note and calls.
Is there any way to boost the performance?? or any other alternative to solve the speed issue?