2042145 - Places: Optimize expiration_notify INSERT queries

Status: NEW

(Toolkit :: Places, task, P3)

Description

[Marco Bonardo [:mak]]

The PlacesExpiration module runs several INSERT INTO expiration_notify queries on a repeating timer (every 3–9 minutes). Three of these queries have performance problems that cause them to be reported as slow, particularly on larger history databases.

Comment 1

[Marco Bonardo [:mak]]

Attachment: WIP: Bug 2042145 - Avoid double CTE scan in QUERY_FIND_EXOTIC_VISITS_TO_EXPIRE.

The UNION ALL caused SQLite to re-evaluate the CTE (a full
moz_historyvisits JOIN moz_places scan) for each arm. Merge
the two arms into a single OR condition to scan the CTE once.