Posts

For more information, see the search syntax documentation. Search results are sorted by creation date.

Search Results

Site and Policy » Avatars and Post/Thread Counts not updating » Post 2

Clover the Clever
Princess of Love - Extra special version for those who participated in the Canterlot Wedding 10th anniversary event by contributing art.
A Perfectly Normal Pony - <@CloverTheClever> I'd pay to see Carcer in a fursuit
Always Codes Drunk - It explains a lot
From the Night - I have technically banned myself a bunch of times...
Since the Beginning  - User number zero

Lord and Saviour
The majority of times you click on a topic and read it we haven’t touched the posts or users in the database at all. This is massively fast, obviously, and means better page load times for you everywhere on the site (slow forums = slow images, and vice versa - everything shares application server backends).
 
If we have to check each post to make sure our counts are precisely up to date we have to hit both users and posts up for info.
 
Most people don’t notice the difference, and all the caches do have reasonable (hours at most) expiry times set, so your data will be consistent everywhere eventually.
 
We felt it was a damn good tradeoff for the performance gain. If we get a lot of people complaining we may look into ways we can improve this without losing the performance - there are a few approaches we’re already looking at.

Site and Policy » Avatars and Post/Thread Counts not updating » Post 1

Carcer
Bronze Bit -
Happy Derpy! -
A Perfectly Normal Pony - <Carcer> "Officer, unless I threatened to **** him in the ass, I don't believe I could have reasonably expected him to stop using my website."
Since the Beginning  - Posted the very first image. Indexes start at zero!

Inexplicably in power
This is to do with the way we cache fragments for efficiency. The information on those old posts is part of the cache, which will expire eventually, and then will be up to date as of the time the cache refreshes. The reason we have these caches to begin with is because dynamically generating the postcount/avatar display from the user data in the DB is very inefficient - caching allows us to significantly speed up browsing and reduce server load.
 
Invalidating the caches of every single post a user has made every time they post a new reply or change their avatar would be a performance degradation but I’m not sure how much of one (also one which would obviously get worse the more time that goes by and the larger the forum becomes). Clover would have to investigate. It’s possible we could reduce the expiry time on the caches to make them update much sooner - maybe let them be a few minutes out at most - but I’m not sure how much impact that would have, either.

Site and Policy » Avatars and Post/Thread Counts not updating » Topic Opener

BronyHeresy
Thread Starter - Word Associaton

Hey mods,
 
I was looking back at my posts, and discovered that the older a post is, the lower its thread/post count.
 
This is counter-intuitive for just about every forum user out there. If you could see about fixing this so that the username portion of each post displays current information rather than what the information was at time of posting, I’m sure it would be much appreciated by the userbase.
 
Your Humble Servant
 
-BH

Default search

If you do not specify a field to search over, the search engine will search for posts with a body that is similar to the query's word stems. For example, posts containing the words winged humanization, wings, and spread wings would all be found by a search for wing, but sewing would not be.

Allowed fields

Field SelectorTypeDescriptionExample
authorLiteralMatches the author of this post. Anonymous authors will never match this term.author:Joey
bodyFull TextMatches the body of this post. This is the default field.body:test
created_atDate/Time RangeMatches the creation time of this post.created_at:2015
idNumeric RangeMatches the numeric surrogate key for this post.id:1000000
myMetamy:posts matches posts you have posted if you are signed in. my:posts
subjectFull TextMatches the title of the topic.subject:time wasting thread
topic_idLiteralMatches the numeric surrogate key for the topic this post belongs to.topic_id:7000
topic_positionNumeric RangeMatches the offset from the beginning of the topic of this post. Positions begin at 0.topic_position:0
updated_atDate/Time RangeMatches the creation or last edit time of this post.updated_at.gte:2 weeks ago
user_idLiteralMatches posts with the specified user_id. Anonymous users will never match this term.user_id:211190
forumLiteralMatches the short name for the forum this post belongs to.forum:meta