How sys_view_count and kb_use table works?


Description

How sys_view_count and kb_use table works?

Resolution

Whenever an article is viewed from OOB article view page like kb_view or kb_article_view page, we increment the sys_view_count field for that article and at the same time we raise an event to add a row in kb_use table.

At the end of the day, a scheduled job runs to make sure that there is sync between the no of records in kb_use table for an article and the sys_view_count of the article.