aheathershaw/blue-twilight
1
0
Fork 0
Code Issues 32 Pull Requests Releases 15 Wiki Activity

Repetitive SQL queries being run against configuration table #117

New Issue
Closed
opened 2018-10-15 13:56:43 +01:00 by aheathershaw · 1 comment
aheathershaw commented 2018-10-15 13:56:43 +01:00
Owner
Copy Link
Copy Source

Whilst analysing SQL queries for a new feature, I've noticed that a large number of select * from configuration where key = ? queries are being run.

We could cache the contents of the table once per request - and use the cache to avoid repeated lookups.

Whilst analysing SQL queries for a new feature, I've noticed that a large number of `select * from configuration where key = ?` queries are being run. We could cache the contents of the table once per request - and use the cache to avoid repeated lookups.
aheathershaw added this to the Version 2.2.0-beta.1 milestone 2018-10-15 13:56:43 +01:00
aheathershaw self-assigned this 2018-10-15 13:56:43 +01:00
aheathershaw added the bugenhancement labels 2018-10-15 13:56:43 +01:00
aheathershaw commented 2018-10-15 13:58:36 +01:00
Author
Owner
Copy Link
Copy Source

This change has resulted in a dramatic improvement in the perception of the speed of the system.

This change has resulted in a dramatic improvement in the perception of the speed of the system.
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
bug
enhancement
feature
invalid
task
wip
No Label bug enhancement
Milestone
No items
No Milestone Version 2.2.0-beta.1
Assignees
Clear assignees
aheathershaw (Andy Heathershaw)
No Assignees aheathershaw
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: aheathershaw/blue-twilight#117
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?