Consider periodically running ANALYZE to make queries faster

RESOLVED INCOMPLETE

Status

()

Firefox for iOS
Data Storage
RESOLVED INCOMPLETE
2 years ago
2 years ago

People

(Reporter: rnewman, Unassigned)

Tracking

({perf})

unspecified
All
iOS

Firefox Tracking Flags

(fxios1.3+)

Details

(Reporter)

Description

2 years ago
http://www.sqlite.org/lang_analyze.html

We should measure to see if this helps.

We should be prepared to re-analyze when the weight of the database shifts -- e.g., after adding lots of visits or URLs.
(Reporter)

Updated

2 years ago
Flags: needinfo?(sleroux)
Run ANALYZE on DB long query
Flags: needinfo?(sleroux)
(Reporter)

Comment 2

2 years ago
I just did this and didn't see a measurable difference in top sites query timing, probably because there's not much one can do to improve a scanning query like that.

We can revisit this when we materialize frecency data: it'll make a difference then.
Status: NEW → RESOLVED
Last Resolved: 2 years ago
Resolution: --- → INCOMPLETE
tracking-fxios: ? → 1.3+
You need to log in before you can comment on or make changes to this bug.