Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[WIP] statistik #146

Closed
wants to merge 16 commits into from
Closed

[WIP] statistik #146

wants to merge 16 commits into from

Conversation

khfiii
Copy link
Contributor

@khfiii khfiii commented Nov 15, 2023

  • Submission Statistic ( wait for submission feature )

@khfiii khfiii linked an issue Nov 15, 2023 that may be closed by this pull request
@khfiii
Copy link
Contributor Author

khfiii commented Nov 15, 2023

Feature have been added

  • User and role count
  • Website visit count

how the website counts the number of visitors who access the conference page?

it work with the following counter 5 standard called session approximation each user have unique visits each day by 3 criteria:

  • the user IP address;

  • the user-agent;

  • the date + the time of the visit (between 0 and 23; minutes and seconds are not considered)

Meaning, when the users access the page multiple times in a day time frame, it will see just one record related to them.

@khfiii
Copy link
Contributor Author

khfiii commented Nov 16, 2023

Problem found
There is a problem when performing an aggregate query, namely that the total visit data is not updated unless the cache is updated. This problem can be solved by performing an eager load query, but it is feared that there will be an eager load overload if the frequency of data retrieved is to high.Look at this.

Data Visit Increment one in database
Screenshot Capture - 2023-11-16 - 08-31-04

But the statistic dashboard still 3
Screenshot Capture - 2023-11-16 - 08-31-35

It will increment if data caches is cleared
Screenshot Capture - 2023-11-16 - 08-34-45

Data will increment one
Screenshot Capture - 2023-11-16 - 08-35-12

List of reference to solve problem

  • Change query to performing an eager load query
  • Doing cache clear and optimize clear after get total visit

@khfiii
Copy link
Contributor Author

khfiii commented Nov 23, 2023

@rahmanramsi rahmanramsi closed this Apr 3, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

Statistik
2 participants