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)
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.
Reporter | ||
Updated•9 years ago
|
Flags: needinfo?(sleroux)
Reporter | ||
Comment 2•9 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
Closed: 9 years ago
Resolution: --- → INCOMPLETE
Updated•9 years ago
|
You need to log in
before you can comment on or make changes to this bug.
Description
•