Repetitive SQL queries being run against configuration table #117
Etiquetas
Sem marco
Sem responsável
1 participante(s)
Notificações
Data limite
Data limite não informada.
Dependências
Nenhuma dependência definida.
Referência: aheathershaw/blue-twilight#117
Carregando…
Referência em uma nova issue
Nenhuma descrição fornecida.
Excluir branch "%!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.