dexie/Dexie.js

Performance issue when fetching/reading large data list using Table.get()

Open

#1,170 创建于 2020年11月13日

在 GitHub 查看
 (4 评论) (0 反应) (0 负责人)JavaScript (10,304 star) (625 fork)batch import
Help wanted

描述

Good day Sirs!

I'm a newbie in terms of using Dexie.js. So my issue is almost identical with #1167

I'm using v.3.0.1 and also in React.

In my case I need to read almost 50,000 items, which causes my whole page to be unresponsive for almost 10 secs. Is there a better solution against this? const data = db[table].get({ id: row }); //I'll just refer to the code of #1167 since I'm also using db.table.get()

Thank you so much in advance!

贡献者指南

技术栈
javascript
领域
frontenddatabaseperformance
议题类型
performance
难度面向新贡献者的预计实现难度，1 表示很小改动，5 表示专家级工作。
3
预计时间有经验贡献者完成调查、实现、测试并准备 pull request 的粗略时间范围。
half day
活动状态议题当前的可参与程度：新鲜、活跃、陈旧、阻塞或等待维护者输入。
stale
清晰度议题是否清楚说明期望改动、验收标准和下一步。
mostly clear
前置要求
Familiarity with Dexie.js APIUnderstanding of IndexedDB
新手友好度1-100 的估计分数，表示该议题对首次贡献者的友好程度。
45
研究方向
The issue reports a performance problem when fetching 50,000 items using Table.get() in Dexie.js. It references a similar issue #1167. Investigate whether the problem can be mitigated by using alternatives like Table.toArray() with pagination or using a cursor and batch processing. Check the comments in the issue for any suggested workarounds or discussions about the underlying IndexedDB limitations.