Dashboard slow to load.

What kind of database?

sql on 123-reg.co.uk and php7.3

This is from the server you are using

yes I think I will raise a ticket with 123-reg and see what they come back with. No doubt I will have to upgrade or something at an extra cost.

Make sure that you followed the advice in this article.

The very first and the most important step is test the same app on another web server i.e. on local machine and on Demo Account. This way you can see if this is a server issue or an application/database issue.

Thanks I havent tried view in browser for a while as it stopped working a while ago. Tried it now and all is good and my dashboard loads in less than 5 seconds?
The dashboard looked slightly different local to my server so I deleted all files and re uploaded the project. Still the same dashboard takes an age to load.

123-reg reply:-
Hi Dean,
I’ve looked into this and cannot see any obvious issues in the error logs that would show issues with website performance.
I did add a php.ini file with the below values to see if this will help with the issue you encounter:
memory_limit = 512M max_execution_time = 120
You can also review your database query scripts to see if these can be optimized for better performance.
From what I can see server side all looks to be OK at the moment.

Kind Regards,

Vladut 123-reg

You need to continue troubleshooting. Did you have a chance to read the whole article? Did you test the same app on Demo Account or on another web server?

Yes I tested the app on demo account and it works fine loads all 4 graphs on dashboard in less than a second.
And it works superb on my local machine using View in Browser.

123-reg reply:-
Hi Dean,
We’ve further investigated the reported issues and couldn’t find anything that indicates the website is slow.
I’ve accessed the link provided and logged on with the username and password and the dashboard loaded practically instantly.
A website that is running locally will always run in a different way since the platforms are different and such situations cannot be compared (different operating systems, different web servers, different MySQL engines, different resources).
I would recommend switching to a cPanel package from our current offer: https://www.123-reg.co.uk/web-hosting/
If the cPanel is not suitable, we can offer a full refund, no questions asked within the 30 day MBG.

Kind Regards,

You can continue troubleshooting because there is a whole lot of things from that article you can do to find out which specific dashboard element or SQL query causes the trouble. However it already looks like you need at least try the new web hosting.

Couldnt find a copy of Firebug. Still have a few things to try in the article.

Ive tried a few things from the article but not had many improvements. The last thing to try is the debug where I would see the sql queries at the top of the page.
One thing I noted on the demo account is that only my first two months data appeared, ie I have data from Jan 2020 right through to this month Aug 2022.
As the dashboard loads in an instant on the demo account I backed up my sql and then deleted all but the first two months data but still the dashboard slow on 123-reg host. : (
The linux server that I am on is very old and it maybe a good idea anyway to upgrade to the newer hosing packages that they have.

It sounds like you really need a different web hosting/web server.

Yes,
I reverted back to 10.7 build 38571 that I downloaded on 11th January and I used my project backup file from same date. Wiped the server and re uploaded a fresh and still have the same problem with slow dashboard.
Im convinced now that it is the server side as it started going slow in June.

I guess there was some sort of software or hardware upgrade on your server and this is what changed the performance. I'm just guessing of course.

Thank you for the help and patients here Admin. Nothing to do with PHPRunner or my project but something on my web host 123-reg.co.uk that I will probably never be informed?
Customer has had two months of waiting 5 mins for dashboard landing page to load before they could input their data each day.
Everything is zipping now. Much appreciated for the help and tips. ☺