I have a really slow SuiteCRM 8.3, which was recently installed. There are barely 6 test users in it, and very less data. I am ready to go live with all configs done, but the speed is too slow and I fear user experience will be poor. The server I’m using is fast with a lot of resources, all other apps work fine on it.
@pgr suggested I run a query on MySQL, the output is:
Does this mean there’s an issue with the database?
No, that doesn’t look like a database problem.
Try looking ofr other possible causes of delays (if you can find error messages in logs, those usually provide clues)
I’ve done a fresh install of 8.3 on the server. The admin login was fast for a few minutes, I configured it same as 8.1 and by the time I was done, it had become slow. I have disable a number of modules - other than that, there is no data, still its slow.
PHP memory limit is 512M, DNS & network has no issues. Instead of opcache, the server has memcache enabled. Any other ideas?
I do see some undefined buttons, specially on pop-ups. Nothing else is broken though. This gives me the feeling that file permissions or ownerships are not ok. I can’t access the server through terminal, and getting all the permissions etc correct through FTP seems to be a big task.
What are the chances the slow speed is due to file permissions?
I’m still struggling with a very slow SuiteCRM on a very powerful server, with no data at all.
Debug level log shows:
Thu Jun 29 23:46:26 2023 [20009][-none-][INFO] Query:SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = ‘Active’ and deleted = 0
Thu Jun 29 23:46:26 2023 [20009][-none-][INFO] Query Execution Time:8.2015991210938E-5
That’s a really long time to execute a simple query. Almost all queries are above 6.5 seconds.
Any other suggestions @pgr would really help, thanks.
Your case is really strange, I don’t know… Maybe it’s some database or php bug, you could try your upgrading some of the pieces in your stack…
I upgraded PHP from 8.0 to 8.1. At the same time, I have enabled both memcached and opcache. I don’t know which of these worked but the speed seems to have increased a bit. Will keep testing to see if it remains fast.
Maybe I am wrong, but doesn’t that E-5 at the end mean * 10 (power -5) - ie it is not 8.2 seconds but 0.000082 seconds?
Query Execution Time:8.2015991210938E-5
Can you make a video of the page load, so we can see what exactly the user sees?