After the upgrade from 4.9.0 to 4.16.0, the query time is longer
還沒有人認領這個 Issue。
評估
- 難度
- 4/5
- 預估耗時
- 3-5 天
- 新手友好度
- 38/100
- Issue 類型
- 缺陷
- 描述清晰度
- 需要釐清
- 活躍度
- 活躍
- 技術堆疊
- android, c
研究方向
No source file or test is named. Start by reproducing the Android scenario with WAL enabled and many SQL queries, then compare versions 4.13.0 and 4.14.0 while varying KDF_inter; done means identifying the regression and providing a verified performance improvement without disabling WAL.
由索引模型根據 Issue 內容生成。
描述
According to my testing, version 4.13.0 is okay, but it starts to deteriorate from version 4.14.0 onwards.
Scenario: I am running the environment in an Android app with WAL enabled. When the app is opened for the first time, the query performance deteriorates, but after some time, the query performance returns to normal.
My speculation: Version 4.13.0 replaced the default encryption component, which significantly increased the computational time for each key derivation function (KDF) operation.
My tests:
Test 1: Disabling WAL improved the query performance significantly.
Test 2: Setting KDF_inter = 64000 improved the query performance significantly.
In version 4.9.0, when the app is opened for the first time, under a large number of SQL queries, the longest read time is <500ms.
In version 4.14.0, when the app is opened for the first time, under a large number of SQL queries, the longest read time is 3s to 7s.
- 主要語言
- C
- 星號
- 7.3k
- 分支
- 1.4k
- PR 合併指標
- 30 天內沒有已合併 PR
貢獻指南
從這裡開始
- 先讀完整個 Issue，再讀專案的貢獻指南。
- 在 Issue 下留言說明你要接手 —— 這能避免兩個人做同樣的事。
- Fork 儲存庫，在一個分支上完成修改。
- 送出 Pull Request，並在描述裡引用這個 Issue 編號。
sqlcipher/sqlcipher 的其他 Issue
-
難度 2/5 1-3 小時 新手友好度 68/100
-
難度 4/5 3-5 天 新手友好度 55/100
-
難度 4/5 3-5 天 新手友好度 68/100
-
難度 3/5 1-2 天 新手友好度 52/100
-
難度 5/5 一週以上 新手友好度 25/100
查看 sqlcipher/sqlcipher 的全部 Issue
相似的 Issue
-
難度 2/5 1-3 小時 新手友好度 88/100
zephyrproject-rtos/zephyr#119726 ·
-
[Bounty proposal] fix(web): memory insights count an evening memory on the next day ($25 proposed) 未關閉
難度 2/5 1-3 小時 新手友好度 84/100
BasedHardware/omi#15320 ·
-
[adam] AdamNet network read doesn't cap to MAX_ADAM_PACKET_LEN, overflows client receive buffers 未關閉
難度 2/5 1-3 小時 新手友好度 88/100
FujiNetWIFI/fujinet-firmware#1649 · 2 則留言 ·
-
難度 2/5 1-3 小時 新手友好度 68/100
HarbourMasters/Shipwright#7229 ·
-
難度 2/5 1-3 小時 新手友好度 72/100
riscv-software-src/riscv-isa-sim#2435 · 1 則留言 ·