Home / Forums / DynamiX Support / Very very big problem for all theme user?

Viewing 15 posts - 1 through 15 (of 35 total)
  • Author
    Posts

  • HammeR
    Participant

    I have already told that I have problems with the performance.
    In my second blog I have not the problem. I’ve watched with my provider and found that one side has over 1000 queries every time. I mean 50-70 queries should be the limit.
    The number appears at the bottom left.

    Insert in footer.php:
    < ?php echo $wpdb->num_queries; ?> database queries in < ?php timer_stop(1); ?>

    http://www.360weggis.ch and http://www.vrpix.ch.
    On the side of http://www.360weggis.ch I have about 350 posts and pages. On the side of http://www.360weggis.ch I have about 55 posts and pages.

    With each post I have more queries. This can not continue. I have disabled all plugins, but this is not the problem. An expert from the provider sent me this, I do not know if this helps that.

    #################################

    Das erste, was im strace (leider nicht vollständig) auffällt, ist sowas:

    SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_
    id = tt.term_taxonomy_id WHERE tt.taxonomy IN (‘category’) AND tr.object_id IN (369) ORDER BY t.name ASC

    root@ovm101:/home/www/p126933/html > grep -c ‘JOIN.*ORDER’ /tmp/p126933-11913
    18

    Tatsaechlich wird dieses unsägliche Konstrukt von JOIN+ORDER aber schnell erledigt, da hier nur wenige Daten vorliegen:
    root@ovm101:~ > time mysql -h172.17.201.62 usr_p126933_2 -ss -e ‘SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN (“category”, “post_tag”) AND tr.object_id IN (1617, 1611, 1606, 1573, 1568, 1548, 364, 1294, 1291) ORDER BY t.name ASC;’ >/dev/null

    real 0m0.006s
    user 0m0.000s
    sys 0m0.000s

    Eine Einzelne Abfrage wird sehr schnell ausgewertet.

    Es erfolgt jedoch nicht nur eine Abfrage, sondern “1032”.

    root@ovm101:/home/www/p126933/html > grep -c ‘SELECT .* WHERE .* IN’ /tmp/p126933-11913
    361
    root@ovm101:/home/www/p126933/html > grep -c ‘SELECT .* FROM wp_postmeta WHERE post_id IN ‘ /tmp/p126933-11913
    339
    root@ovm101:/home/www/p126933/html > grep -c SELECT /tmp/p126933-11913
    1032

    Wenn man mal von 6 ms pro Abfrage ausgeht (s.o.), dann machen über 1000 Abfragen (!!) …
    root@ovm101:/home/www/p126933/html > grep -c SELECT /tmp/p126933-11913
    1032
    … schon über 6 Sekunden aus.

    ###############################

    I have also created a new database and imported the posts and pages. without plug-ins. The problem is the same.

    Ist das bei anderen auch so? Haben das Problem alle?
    @Andy-CWZAdmin ich kann dir einen Login geben wenn dir das was hilft.


    HammeR
    Participant

    OH sorry… i use Translater 🙁

    Ist das bei anderen auch so? Haben das Problem alle?
    @Andy-CWZAdmin ich kann dir einen Login geben wenn dir das was hilft.
    ____________________________________

    If the other too? All have the problem?
    @ Andy-I CWZAdmin can give you a login if this will help you something.


    Flickapix Dezign
    Participant

    have you tested with a different theme? have all post/page revisions been deleted from database? if anything id say its a wordpress thing and not theme related.

    be nice if someone could translate the above into english 🙂

    Andy
    Andy
    Keymaster

    I have a feeling I know what it is.

    Open functions.php file and search for Add default postorder number

    comment out this code (or remove for the time being) and see if that helps.

    In the next version I’ve changed this bit of code anyway (it’s not my finest I know).

    🙂


    HammeR
    Participant

    Yes, if I use the default theme, everything is OK. I have two days testing everything.

    http://translate.google.com 😉

    Andy
    Andy
    Keymaster

    Did you try what I said?


    HammeR
    Participant

    387 database queries in 4,143

    better, but 400 are not much too much?


    HammeR
    Participant

    70 database queries in 0,721

    on my other Blog VRpix.ch

    Andy
    Andy
    Keymaster

    So that’s about right now?

    387 divided by 70 = 5.5

    5.5 * 0.72 = 3.96seconds

    Andy
    Andy
    Keymaster

    Ignore that ^^

    Are you just not sure why there are 387 db queries?

    Which page are you testing it on and what are you using to test it?


    HammeR
    Participant

    i insert < ?php echo $wpdb->num_queries; ?> database queries in < ?php timer_stop(1); ?> in footer.php of Theme.

    This page is almost empty. (See below left in footer)
    http://www.360weggis.ch/kugelpanorama/

    Blog Site
    http://www.360weggis.ch/blog/

    Map Plugin (1305 database queries in 6,975) another problem 🙁
    http://www.360weggis.ch/karte/


    HammeR
    Participant

    Sorry can not post the code here…

    http://stackoverflow.com/questions/14873/how-do-i-display-database-query-statistics-on-wordpress-site

    Andy
    Andy
    Keymaster

    I’ve added it to the bottom of this site.

    Is there supposed to be a benchmark for this?


    HammeR
    Participant

    I know no other way to test internal speed.

    The page I test most with http://tools.pingdom.com or Firebug ( Page Speed)

    The question is… how-many-queries-are-too-many
    http://weblogtoolscollection.com/archives/2008/07/12/how-many-queries-are-too-many/

    Andy
    Andy
    Keymaster

    Ok, I’ve found a way where I can dramatically increase the performance, give me some time and I’ll give you the code 😉

Viewing 15 posts - 1 through 15 (of 35 total)

You must be logged in to reply to this topic.