Closed Bug 619821 Opened 10 years ago Closed 7 years ago

Use SQLite virtual tables for history

Categories

(Toolkit :: Places, defect)

x86
Linux
defect
Not set
normal

Tracking

()

RESOLVED WONTFIX

People

(Reporter: taras.mozilla, Unassigned)

References

(Blocks 1 open bug)

Details

(Whiteboard: [Snappy:P3][wontfix?])

This will allow us to do a custom backend that uses less disk space and causes less disk io.
http://www.sqlite.org/lang_createvtab.html
Whiteboard: [Snappy]
Whiteboard: [Snappy] → [Snappy:P3]
Taras, I think getting this measurement would be really expensive, since we'd need to write a complete backend to be able to measure it.
Moreover virtual tables can't use indices, so even if we could join that could end up being slower than we expect.
While the idea is interesting, the current visits storage situation is not that critical, since it's a table that only supports additions and removals of mostly numerical data. And we now also have only async APIs for additions (removals in progress).
I think we could wontfix this.
Flags: needinfo?(taras.mozilla)
Whiteboard: [Snappy:P3] → [Snappy:P3][wontfix?]
ok
Status: NEW → RESOLVED
Closed: 7 years ago
Flags: needinfo?(taras.mozilla)
Resolution: --- → WONTFIX
You need to log in before you can comment on or make changes to this bug.