Repetitive SQL queries being run against configuration table #117
標籤
未選擇里程碑
沒有負責人
1 參與者
通知
截止日期
未設定截止日期。
先決條件
未設定先決條件。
參考: aheathershaw/blue-twilight#117
載入中…
新增問題並參考
No description provided.
刪除分支「%!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.