Chewing_Bever
/
otter
1
0
Fork 0
Code Issues 17 Packages Releases 4 Activity

Investigate query optimizations #4

New Issue
Open
opened 2025-03-04 20:27:53 +01:00 by Jef Roosens · 0 comments
Jef Roosens commented 2025-03-04 20:27:53 +01:00
Owner

The database needs to perform some complex-ish queries. Debug logs should be added that output the performed SQL queries. These can then be analyzed using EXPLAIN QUERY to identify possible optimization areas, probably using indexes.

The database needs to perform some complex-ish queries. Debug logs should be added that output the performed SQL queries. These can then be analyzed using `EXPLAIN QUERY` to identify possible optimization areas, probably using indexes.
Jef Roosens added the
enhancement
 label 2025-03-04 20:27:53 +01:00
Jef Roosens self-assigned this 2025-03-04 20:27:54 +01:00
Jef Roosens added this to the (deleted) milestone 2025-03-16 20:37:29 +01:00
Jef Roosens removed this from the (deleted) milestone 2025-06-06 12:24:41 +02:00
Jef Roosens removed their assignment 2026-02-22 19:58:39 +01:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
main
signup-links
episode-actions
0.3.0
0.2.1
0.2.0
0.1.0
Labels
Clear labels   
bug

Something is not working   
duplicate

This issue or pull request already exists   
enhancement

New feature   
epic

Large-scale feature comprised of multiple stories   
help wanted

Need some help   
invalid

Something is wrong   
question

More information is needed   
story

Description of a feature to add   
wontfix

This won't be fixed
No Label
bug
duplicate
enhancement
epic
help wanted
invalid
question
story
wontfix
Milestone
Clear milestone
No items
No Milestone
Assignees
Clear assignees
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: Chewing_Bever/otter#4
There is no content yet.
Delete Branch "%!s(<nil>)"

Deleting a branch is permanent. Although the deleted branch may exist for a short time before cleaning up, in most cases it CANNOT be undone. Continue?