Page very slow

  • Ok, I have enquired with my ISP in regards to apparent slow-ness at https://www.lamson.com.au

    Here is the response:

    I have sent this to our Network Engineers for investigation, and they have
    advised the following information:

    When doing a query of a customers database:

    mysql> select * from wp_term_relationships;
    +———–+——————+————+
    | object_id | term_taxonomy_id | term_order |
    +———–+——————+————+
    <snip>
    +———–+——————+————+
    49 rows in set (0.00 sec)

    mysql>

    This is quick. the wp_posts; takes a while to read, but this is also based on
    how much data is in it.

    mysql> select * from wp_posts;
    <snip>
    41 rows in set (6.85 sec)

    Word press will query this table multiple times to get this information which
    could be causing the delay.

    A query optimisation on wordpress could fix this – however its not supported.

    In other words, the slowness is simply due to the way WordPress queries the SQL
    database.

    I hope this information will be of some assistance.

    Thoughts? Any way to fix the slowness?

Viewing 4 replies - 1 through 4 (of 4 total)

  • Slow getting 41 rows? This has nothing to do with WordPress, but rather the MySQL Server. Yes, WordPress will indeed slow down with a DB that is that slow.

    How to fix the slowness? Get a better hosting provider or move to a dedicated MySQL server. They are cheap money these days.

    They say that WordPress needs a query optimization – tell them to take a hike!

    Here’s a response on the same query from my WordPress DB:

    SELECT *
    FROM wp_posts

    (314 total, Query took 0.0650 sec)

    My 314 posts took .065 seconds. Your 41 took 6.85 seconds.

    They say:

    the wp_posts; takes a while to read, but this is also based on how much data is in it.

    Yes, that’s true, but 41 posts isn’t big at all. My 300+ isn’t even big. Some people have literally thousands of posts in WordPress. A properly optimized server should do MUCH, MUCH better than the 6.85 seconds.

    Sorry to say it, but I think your hosting provider is stinky and pointing the finger elsewhere when they should be working on optimizing their own setup. ??

    OK, maybe that isn’t fair. Maybe it is the level of service you are paying for? I can’t slam a provider who is providing low cost service. Anyway, I’d fix the database response time before I’d ever start worrying about optimizing WordPress queries.

    Just my opinion though.

    Best of luck!

    Cheers,
    A

    Thread Starter maxwolfie2

    (@maxwolfie2)

    Thanks A

    I will re email them and tell them the news

    Sure thing! Did they have a different response? ??

    Thread Starter maxwolfie2

    (@maxwolfie2)

    Yeah, the response was:

    Hi Greg,

    Load averages on the SQL server are low, and this issue does not seem to occur
    for other hosted SQL customers, so I am unable advise anything further at this
    stage. If you could call us while the problem is occuring we can look into it
    directly.

    Regards

    ..

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Page very slow’ is closed to new replies.