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

Load test SQL scripts for ranking #35

Open
RodionGork opened this issue Nov 9, 2018 · 0 comments
Open

Load test SQL scripts for ranking #35

RodionGork opened this issue Nov 9, 2018 · 0 comments

Comments

@RodionGork
Copy link
Member

User ranking recalculation is currently implemented like this:

we have tables taskstats and userstats and their corresponding views, from which they are filled. See
here for sql and here for update invocation.

It is very interesting (crucial) to know how this will work when we have many users and tasks.

So. Create some script to populate database with about 1000 tasks and 100000 users. Make each user solve at least 10 random tasks. Then invoke ranking recalculation. Check how much time it will take.

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

No branches or pull requests

1 participant