Repetitive SQL queries being run against configuration table #117

Closed
opened 2018-10-15 13:56:43 +01:00 by aheathershaw · 1 comment
Owner

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
bug
enhancement
labels 2018-10-15 13:56:43 +01:00
Author
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 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: aheathershaw/blue-twilight#117
No description provided.