559687 - Load cookies.sqlite lazily

Status: RESOLVED DUPLICATE of bug 572223

(Core :: Networking: Cookies, defect)

Description

[[e-mail]]

Taras can put some stats here, but he mentioned that eagerly loading cookies.sqlite on startup generates a ton of I/O operations.

To do this we'd need to add a column to the db, baseDomain, and then index on it. Then, when reading in cookies on startup, we load just those required for the pageload. This would happen a few times for the different base domains hit by a given page. Each operation would block, but it'd be faster than loading the whole thing in for sure.

After that, we can either load the whole thing in on a background thread, or keep it lazy. The latter will be hard, I think, if we want to preserve our invariants of max cookie table size and such. We could make them softer limits, perhaps, but that's getting hard.

A related point is removing expired cookies: we do this on startup also, because typically it results in less to read and thus pays for itself. We'd have to change that.