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

When sorting Data Sources, missing index causes unnecessary delays #2563

Closed
cigamit opened this issue Mar 24, 2019 · 1 comment
Closed

When sorting Data Sources, missing index causes unnecessary delays #2563

cigamit opened this issue Mar 24, 2019 · 1 comment
Labels
bug Undesired behaviour resolved A fixed issue
Milestone

Comments

@cigamit
Copy link
Member

cigamit commented Mar 24, 2019

Describe the bug
On very large Cacti installs, the Data Sources page may be slow due to a missing index on the name_cache column

To Reproduce
Steps to reproduce the behavior:

  1. Go to Data Source apge
  2. Sort by the ID column, measure time
  3. Sort by the Name column, measure time
  4. Not the increase in time

Expected behavior
Behavior should be consistent between sorted columns

@cigamit cigamit added the bug Undesired behaviour label Mar 24, 2019
@cigamit cigamit added this to the v1.2.3 milestone Mar 24, 2019
@cigamit cigamit added the resolved A fixed issue label Mar 24, 2019
cigamit added a commit that referenced this issue Mar 24, 2019
Sorting by name_cache slow on Data Sources page
@cigamit cigamit closed this as completed Mar 24, 2019
@netniV
Copy link
Member

netniV commented Mar 24, 2019

@TheWitness may need to check for that on Thresholds too where it was added recently.

@netniV netniV changed the title Sorting by name_cache slow on Data Sources page When sorting Data Sources, missing index causes unnecessary delays Mar 30, 2019
@github-actions github-actions bot locked as resolved and limited conversation to collaborators Jun 30, 2020
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
bug Undesired behaviour resolved A fixed issue
Projects
None yet
Development

No branches or pull requests

2 participants