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

Investigate database indexes impact on data listing #229

Open
7 tasks
rafamanzo opened this issue Jul 29, 2016 · 0 comments
Open
7 tasks

Investigate database indexes impact on data listing #229

rafamanzo opened this issue Jul 29, 2016 · 0 comments

Comments

@rafamanzo
Copy link
Member

rafamanzo commented Jul 29, 2016

First proposed by #215 and then isolated at the branch db_indexes (https://github.com/mezuro/kalibro_processor/tree/db_indexes).

We've already seen that those indexes have some impact on insertion times adding 30s to the performance test on the worst case. We need now to investigate if there is real gain on other operations which are essentially reads (in contrast to the aggregation performance test which is biased to data insertion times).

  • Produce performance tests biased to data read
  • Run tests with the indexes proposed at the referred branches
    • MetricResults
    • ModuleResults
    • KalibroModules
    • Repositories
    • Processings
    • ProcessTimes
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant