Today views more than Total views

  • Resolved pkirk

    (@pkirk)


    10 years, 7 months ago

    Since version 2.2.0 I’ve seen a strange thing happening: when a post is still fresh, usually in the same day of the publishing date, sometimes I can see more Today View than Total View.

    Right now I have a post with that behaviour:
    SELECT WTT.cntaccess, WTTD.cntaccess
    FROM wp_top_ten WTT
    INNER JOIN wp_top_ten_daily WTTD ON WTT.postnumber = WTTD.postnumber
    AND WTT.postnumber =213082

    (OK, the query is not one of the best ones)
    returns

    cntaccess	cntaccess
669	123
669	155
669	117
669	105
669	86
669	69
669	15

    As you can see, I have 670 read for today, and, summing, 669 for the whole.

    In this post the difference is only 1 (670 – 669) but it can go over that.

    Does anybody else saw that?

    Thanks,
    —
    P.

    https://wordpress.org/plugins/top-10/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author WebberZone

    (@webberzone)

    10 years, 7 months ago

    Is this for all posts or a specific one. Typically I haven’t seen that happen except if a query failed for whatever reason.

    Thread Starter pkirk

    (@pkirk)

    10 years, 6 months ago

    Seems casual to me. Today I have two new posts and the counting is OK: both “today” and “total” are the same number.

    I don’t know how to check if a query goes wrong.
    The server load is pretty low (less than 5%). I have 30K-40K pageview a day, but it’s nginx’s cached (not the JS that update the count!).

    Thanks,
    —
    P.

    Plugin Author WebberZone

    (@webberzone)

    10 years, 6 months ago

    I’ve seen very few instances of query failure. It typically happened across all posts e.g. the daily posts wouldn’t record due to an error in the database structure.

    My suggestion is to keep an eye on posts and see if there is a major issue that repeats.

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

The topic ‘Today views more than Total views’ is closed to new replies.