Hey all,
today I want to go public with my issues because I am sick of the games RSP support is playing. I am certainly sure that I am not the only one who is experiencing extreme bad execution times for MySQL queries. It was the case when I had a shared hosting package here for my reseller website, then I upgraded to a Semi-Dedicated package and hoped to resolve that issue. But nothing changed. It is still slow. Non cached pages take between 4 to 9 seconds to load, both on Joomla, WordPress, Prestashop or any other script. Support keeps insisting that everything is normal and comes up with the most ridiculous reasons. One time it is the script I am using, another time it is a spamming attack that is going on (which is not true) and another time it is me who is not able to control my websites properly.
I have written a small PHP script that is executing one MySQL query and displays the execution time the query needed. When I had only a few visitors and no load on my websites (3 active sites on the semi-dedicated package at the moment), I executed the script 10 time. I got the following execution times:
Time: 0.31502509117126 s
Time: 0.33386707305908 s
Time: 0.31554698944092 s
Time: 0.32462406158447 s
Time: 0.31726598739624 s
Time: 0.30038499832153 s
Time: 0.43183898925781 s
Time: 0.32075595855713 s
Time: 0.32046604156494 s
Time: 0.32237195968628 s
=================
Average: 0.33021472
Now the average amount of queries per page load that is executed by a CMS is 20 queries. That would be 6.6 seconds alone to execute the SQL queries. Also this is exactly the time my sites need to load uncached. I also had other people have a look and the confirmed that a slow MySQL database server is the reason for the slow sites. The ridiculous thing is that I am paying $20 / mo. here for pretty much nothing. I have hosting accounts on other hosting providers, one of the only costs me 99 cents per month. The average query execution time on their servers is just 0.08 seconds. And guess what? I have a much bigger website on one of them than I have here. It has nearly 3k visitors per day. All is working fine and smooth.
So am I the only one who has such problems and is pissed about it? I guess not. I think only by going public with this issue we can change something. If you are also suffering from bad loading times and want to read out your SQL query times, please contact me through PM. I will then give you the PHP code and you can post the results here.
Regards,
Christopher
today I want to go public with my issues because I am sick of the games RSP support is playing. I am certainly sure that I am not the only one who is experiencing extreme bad execution times for MySQL queries. It was the case when I had a shared hosting package here for my reseller website, then I upgraded to a Semi-Dedicated package and hoped to resolve that issue. But nothing changed. It is still slow. Non cached pages take between 4 to 9 seconds to load, both on Joomla, WordPress, Prestashop or any other script. Support keeps insisting that everything is normal and comes up with the most ridiculous reasons. One time it is the script I am using, another time it is a spamming attack that is going on (which is not true) and another time it is me who is not able to control my websites properly.
I have written a small PHP script that is executing one MySQL query and displays the execution time the query needed. When I had only a few visitors and no load on my websites (3 active sites on the semi-dedicated package at the moment), I executed the script 10 time. I got the following execution times:
Time: 0.31502509117126 s
Time: 0.33386707305908 s
Time: 0.31554698944092 s
Time: 0.32462406158447 s
Time: 0.31726598739624 s
Time: 0.30038499832153 s
Time: 0.43183898925781 s
Time: 0.32075595855713 s
Time: 0.32046604156494 s
Time: 0.32237195968628 s
=================
Average: 0.33021472
Now the average amount of queries per page load that is executed by a CMS is 20 queries. That would be 6.6 seconds alone to execute the SQL queries. Also this is exactly the time my sites need to load uncached. I also had other people have a look and the confirmed that a slow MySQL database server is the reason for the slow sites. The ridiculous thing is that I am paying $20 / mo. here for pretty much nothing. I have hosting accounts on other hosting providers, one of the only costs me 99 cents per month. The average query execution time on their servers is just 0.08 seconds. And guess what? I have a much bigger website on one of them than I have here. It has nearly 3k visitors per day. All is working fine and smooth.
So am I the only one who has such problems and is pissed about it? I guess not. I think only by going public with this issue we can change something. If you are also suffering from bad loading times and want to read out your SQL query times, please contact me through PM. I will then give you the PHP code and you can post the results here.
Regards,
Christopher
Comment