Site speed on production
This topic contains 13 replies, has 3 voices, and was last updated by Stiofan O’Connor 7 years, 2 months ago.
We have moved to a support ticketing system and our forums are now closed.
Open Support TicketTagged: site speed
-
AuthorPosts
-
August 25, 2017 at 6:26 pm #392917
Hi!!!
In recent days finally can mount Listing data to my site (60% of total). At this moment some performance test generated poor results ( executed with Google speed test,pingdom and another load test tool ).First I installed GD Booster and I get very bad results. Later I installed WP Super Cache+Autoptimizer and obtained better numbers but not the result that I have in mind. In general the site feels very slow especially the main page that takes 7 seconds or more to load.The server is dedicated and has a lot of resource.
Please, can you help me to optimize the site?August 25, 2017 at 10:41 pm #392932I’ll get Stiofan to have a look at your question. Thanks.
August 26, 2017 at 9:21 am #392983Hi Jorge,
Please provide wp-admin and FTP (or cpanel if you have it) and i will take a look.
Thanks,
Stiofan
August 26, 2017 at 5:32 pm #393036This reply has been marked as private.August 26, 2017 at 5:58 pm #393044Hi Jorge,
I see a problem with some of the SQL queries which is a bit puzzling as the “easier” ones are taking longer then the more complex ones. If you can give me phpmyadmin database access then i will debug things to find out what is going on.
Thanks,
Stiofan
August 26, 2017 at 6:00 pm #393046P.S. I also enabled server side map clustering (which you need with over 10k listings) and map caching so maps should be faster.
Stiofan
August 26, 2017 at 6:12 pm #393053This reply has been marked as private.August 26, 2017 at 7:14 pm #393069Hi Jorge,
Your cache limits are super small around 1mb which seems to be the main problem as NO queries are being cached.
I ran “SHOW VARIABLES LIKE ‘%query_cache%'” to check this.Try increasing the “query_cache_size” and the “query_cache_limit” to around 50mb and then lets see where we are.
Thanks,
Stiofan
August 26, 2017 at 8:21 pm #393072This reply has been marked as private.August 28, 2017 at 12:44 pm #393211Hi Jorge,
I really would recommend enabling it, its the most efficient way, i have not heard of people deliberately disabling it.
The problem here is with the “ORDER BY” bit of the query, and the problem is mostly with the popular post widget, if we just ask for all listings and order by date, the system needs to get all listings in memory and then order them all just to grab say the top 5, If we limit them to specific listings the order by it is quicker because it has less listings to order, for example on your homepage i have set both widgets to only show it they have images and to only show one category, i tried also narrowing it by featured but it seems you have no featured listings. It has seeded it up but the query caching will help much more.
Stiofan
August 28, 2017 at 4:02 pm #393242I really do not agree with you. I have deliberately disabled it but from MySQL 5.6 (and MariaDb 10.1 if I am not mistaken) this is disabled and deprecated by default. In Mysql 8 it will be totally removed; What I am trying to say is that is going to be very common in the short term.
Query caching in Mysql is not good in high concurrency environments, causes contention and in many cases takes longer than executing the query. Surely that would be an ideal solution if only had the geodirectory installed or applications that mainly perform reading.The only way I could enable query cache is that the queries explicitly carry the ‘SQL_CACHE’ clause to be taken into account by the cache (query_cache_type = 2 or ondemand cache) . In this way my other data base will not be affected.
Im sorry, but insist, the transparent way and the most efficient way is doing it in the application.
August 28, 2017 at 4:55 pm #393249Hi Jorge,
I think it might benefit you here but i’m happy to work with you on other solutions.
Do you have skype? If so it might be better to be able to have instant communications with you (text) and we can find the best solutions.What is your skype ID?
Thanks,
Stiofan
P.S. i’m in the UK so it might be tomorrow before we can chatting.August 29, 2017 at 5:25 pm #393379This reply has been marked as private.August 29, 2017 at 5:32 pm #393382Added, but i am in Ireland so i will be finishing for the night soon, ping me when you are online tomorrow.
Thanks,
Stiofan
-
AuthorPosts
We have moved to a support ticketing system and our forums are now closed.
Open Support Ticket