Chewing_Bever/otter
1
0
Fork 0
Code Issues 17 Releases 4 Packages 2 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
Copy link

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 labels
bug
duplicate
enhancement
epic
help wanted
invalid
question
story
wontfix
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
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
No description provided.
Delete branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?