smozgur
Well-known member
We really need "question_asked" and "solution_marked" fields like "message_count" in the User entity to avoid unnecessary queries if we'd like to expose this information in the user profiles. These statistics are really important, because members are encouraged to mark a solution to their questions if they know that they are maintaining a reputation as an asker. Besides, if there is a "question_solution_count" in the entity, then these two (in fact also threads_count besides message_count, because thread count directly represents the contribution and more accurate value than the message count) are also necessary to be saved in the entity. Being a good asker is also important as much as being a good helper.
We are currently doing this by querying the database as a part of a custom add-on we built, and we implemented it very carefully, but it is still a query running against to a table that contains millions of records that could be actually saved if the counters are included to the entity.
We are currently doing this by querying the database as a part of a custom add-on we built, and we implemented it very carefully, but it is still a query running against to a table that contains millions of records that could be actually saved if the counters are included to the entity.
Upvote
4