Bug 201465

Summary: IndexedDB: use SQL COUNT statement for count operation
Product: WebKit Reporter: Sihui Liu <sihui_liu>
Component: New BugsAssignee: Sihui Liu <sihui_liu>
Status: RESOLVED FIXED    
Severity: Normal CC: alecflett, beidson, commit-queue, ews-watchlist, ggaren, jsbell, webkit-bug-importer
Priority: P2 Keywords: InRadar
Version: WebKit Nightly Build   
Hardware: Unspecified   
OS: Unspecified   
Attachments:
Description Flags
Patch
none
Patch none

Sihui Liu
Reported 2019-09-04 11:51:12 PDT
Currently we do count by moving objectStore/index iterator from begin to end and counting the steps, which is slower than using SQL COUNT statement.
Attachments
Patch (9.44 KB, patch)
2019-09-04 11:59 PDT, Sihui Liu 		no flags
DetailsFormatted DiffDiff
Patch (9.43 KB, patch)
2019-09-04 12:24 PDT, Sihui Liu 		no flags
DetailsFormatted DiffDiff
Show Obsolete (1) View All Add attachment proposed patch, testcase, etc.
Sihui Liu
Comment 1 2019-09-04 11:59:01 PDT
Created attachment 377996 [details] Patch
Sihui Liu
Comment 2 2019-09-04 12:24:53 PDT
Created attachment 378000 [details] Patch
Geoffrey Garen
Comment 3 2019-09-05 13:51:02 PDT
Comment on attachment 378000 [details] Patch r=me
WebKit Commit Bot
Comment 4 2019-09-06 11:28:37 PDT
Comment on attachment 378000 [details] Patch Clearing flags on attachment: 378000 Committed r249583: <https://trac.webkit.org/changeset/249583>
WebKit Commit Bot
Comment 5 2019-09-06 11:28:39 PDT
All reviewed patches have been landed. Closing bug.
Radar WebKit Bug Importer
Comment 6 2019-09-06 11:29:21 PDT
<rdar://problem/55120531>
Note You need to log in before you can comment on or make changes to this bug.