Bug 207377 – IndexedDB: index cursor iteration is slow when there are a lot of index records from different object stores

• Status: RESOLVED
• Resolution: FIXED
• Component: WebCore Misc.

[Carlos]

Created attachment 390067 [details]
Bug Reproducer

The fact of having an object store with a lot of data is impacting in the performance of the rest of object stores, making the openCursor operation much slower when using an index (even if the object store that we want to read is almost empty).

Note that when not using an index (IDBIndex), the performance seems to be not affected.

Tested with Safari Technology preview release 100 (Safari 13.2, WebKit 15610.1.2.1) on Mac, and with Safari 13 on iOS.

Steps to reproduce: 

1- Open the attached reproducer, performance.html. An IndexedDB database with two objectStores (testStore and testStore2) is created.
2- Click in “Read data (object store)”, it reads the contents of the object store “testStore2” using the openCursor operation directly with the objectStore. The testStore2 is empty and the read finishes in a few milliseconds.
3- Click in “Read data (index)”, it reads the contents of the object store “testStore2” using the openCursor operation by an index of testStore2. The testStore2 is empty and the read finishes in a few milliseconds.
4- Click in “Populate database” and wait until it finishes. It will populate “testStore” with 250000 records and testStore2 with 10 records.
5- Click in “Read data (object store)”. Reading again testStore2 (which is almost empty, 10 records). It finishes in a few milliseconds.
6- Click in “Read data (index)”. Reading again objectStestStore2tore2 (which is almost empty, 10 records). It takes at least 200 ms

[Radar WebKit Bug Importer]

<rdar://problem/59288679>

[Sihui Liu]

Created attachment 390818 [details]
Patch

[Sihui Liu]

The layout test failure is not caused by the patch.

[WebKit Commit Bot]

Comment on attachment 390818 [details]
Patch

Clearing flags on attachment: 390818

Committed r256738: <https://trac.webkit.org/changeset/256738>

[WebKit Commit Bot]

All reviewed patches have been landed.  Closing bug.