Repetitive SQL queries being run against configuration table #117
Метки
Нет этапа
Нет назначенных лиц
1 участников
Уведомления
Срок выполнения
Срок выполнения не установлен.
Зависимости
Зависимостей нет.
Ссылка: aheathershaw/blue-twilight#117
Загрузка…
Ссылка в новой задаче
Описание отсутствует.
Удалить ветку «%!s(<nil>)»
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?
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.
This change has resulted in a dramatic improvement in the perception of the speed of the system.