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 条评论 ·