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 Ticket

Tagged: 

  • Author
    Posts
  • #392917

    Jorge Adrian Urrego Acosta
    Full Member
    Post count: 22

    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?

    #392932

    Guust
    Moderator
    Post count: 29970

    I’ll get Stiofan to have a look at your question. Thanks.

    #392983

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Hi Jorge,

    Please provide wp-admin and FTP (or cpanel if you have it) and i will take a look.

    Thanks,

    Stiofan

    #393036

    Jorge Adrian Urrego Acosta
    Full Member
    Post count: 22
    This reply has been marked as private.
    #393044

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Hi 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

    #393046

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    P.S. I also enabled server side map clustering (which you need with over 10k listings) and map caching so maps should be faster.

    Stiofan

    #393053

    Jorge Adrian Urrego Acosta
    Full Member
    Post count: 22
    This reply has been marked as private.
    #393069

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Hi 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

    #393072

    Jorge Adrian Urrego Acosta
    Full Member
    Post count: 22
    This reply has been marked as private.
    #393211

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Hi 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

    #393242

    Jorge Adrian Urrego Acosta
    Full Member
    Post count: 22

    I 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.

    #393249

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Hi 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.

    #393379

    Jorge Adrian Urrego Acosta
    Full Member
    Post count: 22
    This reply has been marked as private.
    #393382

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Added, but i am in Ireland so i will be finishing for the night soon, ping me when you are online tomorrow.

    Thanks,

    Stiofan

Viewing 14 posts - 1 through 14 (of 14 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount