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

Fix query for high number of switch operation records #95

Open
zieren opened this issue Mar 27, 2019 · 0 comments
Open

Fix query for high number of switch operation records #95

zieren opened this issue Mar 27, 2019 · 0 comments
Labels
bug p2

Comments

@zieren
Copy link
Owner

zieren commented Mar 27, 2019 •
edited
Loading

Due to a mechanical failure we had a high number of door switch operations (O(10k)). This slowed the query down too much. Maybe just LIMIT to 1000 or so? Look at other queries for similar issues.

Also consider "debouncing" switches for several seconds.

It also seems that the result is truncated (example: 1w back from 2019-03-27 ~09:00).
@zieren zieren changed the title Slowness for high number of switch operation records Fix query for high number of switch operation records Mar 27, 2019
@zieren zieren added p1 and removed p2 labels Mar 27, 2019
@zieren zieren added p2 and removed p1 labels Jan 30, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug p2
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@zieren