bkrztuk wrote:The main problem is that your server response is very long, I advise you change hosting company.
thank you for this. can i show you what they have been saying please because they are trying to tell me its the site but i am being told by 6.97 seconds for the server to respond. I would really value your opinion if you could read what they have put as i feel i am going out of my mind, they keep telling me to buy more stuff from them and i already have a dedicated server. also can you recommend any good hosting companies in the uk.
here is what they are saying
We have installed LiteSpeed with 15 days test license on the server. May I kindly ask you to check the website now. I have checked it using PingDom using US and EU locations and the front-page loads for about 3 - 4 seconds which is pretty good result.
Please note that if you would like to keep the LiteSpeed web service after 15 days license should be purchased. If no license is purchased on the 15th day the web service will be disabled and we will have to switch back to Apache.
Best regards,
Gabriel Reed
Senior Support Team
TMDHosting.com
This is a slow queries log for requests initiated from your website to the database it uses. If you do not have SQL programming knowledge and experience you will have to provide the log to expert local web developer to review and patch your website. These queries will increase the time required for your website to load.
If you believe that the issue is caused from the server you may move all the websites to any other host. If you will be ordering server with the same hardware specifications you will be amazed that there will be no difference and even it may be slower as you will not have there any of the optimization patfches I have mentioned. However it is up to you to check different options.
Hello,
As the php scripts are executing without issues or delay we have enabled the MySQL slow queries logging:
# Time: 120218 8:55:58
# User@Host: in2town2_asd[in2town2_asd] @ localhost []
# Query_time: 7 Lock_time: 0 Rows_sent: 10 Rows_examined: 305768
use in2town2_asd;
SELECT * FROM xlo1m_k2_comments WHERE itemID=30 AND published=1 ORDER BY commentDate DESC LIMIT 0, 10;
# Time: 120218 8:55:59
# User@Host: in2town2_asd[in2town2_asd] @ localhost []
# Query_time: 8 Lock_time: 0 Rows_sent: 10 Rows_examined: 421948
SELECT * FROM xlo1m_k2_comments WHERE itemID=30 AND published=1 ORDER BY commentDate DESC LIMIT 116180, 10;
# Time: 120218 8:56:30
# User@Host: in2town2_asd[in2town2_asd] @ localhost []
# Query_time: 7 Lock_time: 0 Rows_sent: 10 Rows_examined: 305772
SELECT * FROM xlo1m_k2_comments WHERE itemID=30 AND published=1 ORDER BY commentDate DESC LIMIT 0, 10;
There are MySQL queries on your website which will execute for over 8 seconds. These will delay the loading speed of the page where the same are required with the time of the execution.
Currently there are the following extra optimizations installed on your server:
1. Memcache -- this is MySQL caching service which you may enabled on your Joomla or request from your developer to integrate it
2. APC -- This is php caching module which you may also enable for your CMS or request from your developer to complete that
3. You have LiteSpeed web service installed which provides over 20% better performance compared to the Apache
4. You have Varnish static content caching installed which handles the requests for any media/javascript/html pages and provides additional performance optimization
The only extra optimization is to request from your developer to integrate the above caching services as Joomla by default supports only one of these to be enabled. Also your database should be optimized in order to have queries execution time which is 2 seconds or less.
We have reviewed your server hardware and we strongly believe that it is providing the maximum performance possible for the hardware in use. There are absolutely no optimization left to apply on the server except upgrading it to a high class machine with better CPU and more RAM memory.
We understand that for your website to load 6 seconds is not acceptable for you but we already did everything possible to provide the best performance and optimization for the hardware you are using.
However I will now escalate this ticket to our Supervisors again for further review. If any extra information is available they will collect and provide it to you in this ticket.