Open Bug 1780386 Opened 2 years ago

Investigate performance impact of OFFSET

Categories

(Core :: DOM: File, task, P4)

Product:
Core
Component:
DOM: File
Type:
task

Tracking

()

People

(Reporter: jjalkanen, Unassigned)

Details

During directory content iteration, FileSystemDataManagerVersion001 is paging the entries which are sent from the parent to the child process. After going through the first page of results, a new request is sent for the next page, which is fetched from the database using LIMIT and OFFSET.

In the literature, the query performance of OFFSET is said to become poor at large values, and a query on an indexed column is recommended as a replacement.

We should investigate if this case ever occurs in practice, and if so, identify a reasonable way to index the contents so that we don't introduce a high-precision clock and that the results of the iteration are stable in some sense when entries are added or removed between successive requests.

You need to log in before you can comment on or make changes to this bug.