Closed Bug 897081 Opened 12 years ago Closed 9 years ago

Places sometimes issues extremely long SQL statements to remove pages from history

Categories

(Toolkit :: Places, defect)

Product:
Toolkit
Component:
Places
Type:
defect
Priority:
Not set
Severity:
normal

Tracking

()

Status:
RESOLVED DUPLICATE of bug 1047818

People

(Reporter: vladan, Unassigned)

Details

(Keywords: main-thread-io, perf, Whiteboard: [async])

Attachments

(1 file)

Examples of very long SQL statements
1.21 MB, text/plain
Details
The queries used to remove history in Places can sometimes be over 1 million characters long! This is bad for performance and also bloats Telemetry pings (bug 896737). Note: The sample queries are from a Telemetry slowSQL report and the ":private" tokens are a result of anonymization performed by Telemetry code.
we should likely use a temp table for these cases
Whiteboard: [async]
Status: NEW → RESOLVED
Closed: 9 years ago
Resolution: --- → DUPLICATE
You need to log in before you can comment on or make changes to this bug.

Attachment

General

Creator:
Created:
Updated:
Size: