619821 - Use SQLite virtual tables for history

Status: RESOLVED WONTFIX

(Toolkit :: Places, defect)

Description

[(dormant account)]

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

Comment 1

[Marco Bonardo [:mak]]

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.

Comment 2

[(dormant account)]

ok