Closed Bug 1220319 Opened 9 years ago Closed 9 years ago

Consider periodically running ANALYZE to make queries faster

Categories

(Firefox for iOS :: Data Storage, defect)

All
iOS
defect
Not set
normal

Tracking

()

RESOLVED INCOMPLETE
Tracking Status
fxios 1.3+ ---

People

(Reporter: rnewman, Unassigned)

Details

(Keywords: perf)

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.
Flags: needinfo?(sleroux)
Run ANALYZE on DB long query
Flags: needinfo?(sleroux)
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
Closed: 9 years ago
Resolution: --- → INCOMPLETE
You need to log in before you can comment on or make changes to this bug.