What's up with these 1ms views?


(Dave McClure) #1

While working on this query, I noticed that there were some posts that had a number of 1 millisecond views

  select count(1) as tiny_views
  from post_timings
  where msecs = 1
  # tiny_views: 3515

I first noticed about 30 of these views on an “auto close” post in an old topic. That post was created in the last week, and at least one of those views is from a user who has not logged in since June.

Any idea what may be causing those post timing entries?

If I change the query to show anything with less than 100ms, the count doesn’t go up too much:

  select count(1) as tiny_views
  from post_timings
  where msecs < 100
  # tiny_views: 3568

…so there seems to be something special about these 1msec entries:


(Mittineague) #2

I just ran this query on my localhost.

SELECT * 
FROM post_timings 
ORDER BY msecs 

There were quite a few msecs 1

They were all for the same “small action” autoclose post.

My guess is that “system” can post extremely fast.


(Neil Lalonde) #3

This is being done when a topic is being autoclosed (here). When a topic auto-closes, a new post is made to say that the post was automatically closed. Normally that post will be shown as unread, which can be annoying to everyone who has read all the other posts in the topic. So we mark the autoclose post as read by anyone who read all the real posts, and give it a 1 ms read time.

So if you have a lot of auto-closed topics, you’ll see those 1 ms post timing records.