1166814 - Automatically prune visits and history items

Status: RESOLVED DUPLICATE of bug 1131737

(Firefox for iOS :: Data Storage, defect)

Description

[Richard Newman [:rnewman]]

We should clear these, both deleted and not deleted, oldest first, preferring those that have already been synced, as our database swells.

Comment 1

[Richard Newman [:rnewman]]

My browser DB from my 6S is 10MB:

sqlite> select count(*) from favicons;
852

sqlite> select count(*) from visits;
36223

sqlite> select count(*) from domains;
1879

sqlite> select count(*) from tabs;
49

sqlite> select count(*) from favicon_sites;
2540

sqlite> select count(*) from history;
18185

Comment 2

[Richard Newman [:rnewman]]

Attachment: Output of sqlite3_analyzer.

Comment 3

[Richard Newman [:rnewman]]

Note that we _never_ clean up deleted history items for non-Sync users, as far as I can tell; they sit around with is_deleted=1 and a blanked URL, slowing down queries and occupying disk space.

This bug is a two-parter:

1. DELETE existing items with is_deleted. All of them if we aren't Sync users, and old ones if we are.
2. Prune old items when we start running out of space or start slowing down.