Repetitive SQL queries being run against configuration table #117

Nieuw probleem

aheathershaw · 2018-10-15T13:56:43+01:00

aheathershaw reageerde

2018-10-15 13:56:43 +01:00

Eigenaar

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 heeft dit 2018-10-15 13:56:43 +01:00 aan de mijlpaal Version 2.2.0-beta.1 toegevoegd

aheathershaw heeft dit 2018-10-15 13:56:43 +01:00 aan zichzelf toegewezen

aheathershaw voegde de

bug

enhancement

labels 2018-10-15 13:56:43 +01:00 toe

aheathershaw verwees naar dit probleem vanuit commit 2018-10-15 13:58:02 +01:00'

#117: Avoid repeated calls to the configuration table - cache the entire table on the first request and use the cache in subsequent calls

aheathershaw heeft dit probleem gesloten

2018-10-15 13:58:03 +01:00

aheathershaw reageerde

2018-10-15 13:58:36 +01:00