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.