I noticed that everything that goes under the questions active tab is displayed as modified. It doesn't matter even if the question was recently asked or answered. It always displays "modified" no matter what the recent activity took place for a given question.
Is this a default/normal behavior of the "active" tab or does it belongs to status-bydesign category?
Can anyone please explain?
As per Jeff Atwood answer: (Thanks ShadowWizard for the link)
Good idea, but we just don't have that information there without running more queries, which I don't want to do in the listing page.
But that was posted almost 6 years ago, does this answer still valid? Looking at Jeff's answer it seems like he was worried about the additional queries that needed to run i.e. extra overhead and the cost associated with. But, the core software that powers SE's sites and the architecture behind has been improved tremendously over the past six years period. So, I was wondering if it is still a concern or things have changed.
As per the "ben is uǝq backwards" answer:
The asked/modified is static and doesn't necessarily relate to the latest action taken on a post
But, upon hovering on the time shown on Ben's post both i.e. main page and active tab I noticed that they match (see note*) exactly.
2015-07-18 07:32:52Z (main page)
2015-07-18 07:32:52Z (active tab page)
note*: The timestamp of the "active tab" is valid very first time or till any edit is made on the post. Ben hasn't made any edits so you can cross-check the timestamp.
So, it means (my assumption based on timestamp shown) when the active tab listing gets updated there is some kinda query/call made to database to pull the timestamp of the recent activity in this case. So, can't we pull the associated "activity name" (asked, answered, modified, etc.) from the database field with the same call? Or is it stored in some other database? I don't know exactly how the data is stored.