#117 Repetitive SQL queries being run against configuration table

Closed
opened 1 year ago by aheathershaw · 1 comments

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 1 year ago
aheathershaw self-assigned this 1 year ago
aheathershaw added the
bug
label 1 year ago
aheathershaw added the
enhancement
label 1 year ago
aheathershaw commented 1 year ago
Owner

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 Milestone
No Assignees
1 Participants
Due Date

No due date set.

Dependencies

This issue currently doesn't have any dependencies.

Loading…
Cancel
Save
There is no content yet.