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.

Sign up for GitHub

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

Jump to bottom

Graph Automation slowed by in-efficient index selection #4482

Closed
TheWitness opened this issue Nov 27, 2021 · 0 comments
Closed

Graph Automation slowed by in-efficient index selection #4482

TheWitness opened this issue Nov 27, 2021 · 0 comments
Labels
bug Undesired behaviour resolved A fixed issue
Milestone
v1.2.20

Comments

@TheWitness
Copy link
Member

Describe the bug

On very large systems, graph automation can be slowed due to MariaDB/MySQL selecting a poor index to control queries for graphs. In these cases, it's real important to force MariaDB/MySQL to use an optimal index for the queries. The MariaDB/MySQL Query Optimized does not always get it right.

Expected behavior

Faster running automation.
@TheWitness TheWitness added the bug Undesired behaviour label Nov 27, 2021
@TheWitness TheWitness added this to the v1.2.20 milestone Nov 27, 2021
TheWitness added a commit that referenced this issue Nov 27, 2021
@TheWitness
Fixing Issue #4482 - Faster Automation
931eb90 
Graph Automation slowed by in-efficient index selection when creating Graphs
@TheWitness TheWitness added the resolved A fixed issue label Nov 28, 2021
@netniV netniV changed the title Graph Automation slowed by in-efficient index selection when creating Graphs Graph Automation slowed by in-efficient index selection Apr 3, 2022
@github-actions github-actions bot locked and limited conversation to collaborators Dec 2, 2022
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees
No one assigned
Labels
bug Undesired behaviour resolved A fixed issue
Projects
None yet
Milestone
v1.2.20
Development

No branches or pull requests
1 participant
@TheWitness