Evaluate using SQLITE_LIMIT_SQL_LENGTH

NEW
Unassigned

Status

()

Toolkit
Storage
P3
normal
8 months ago
8 months ago

People

(Reporter: mak, Unassigned)

Tracking

(Depends on: 1 bug)

Trunk
Points:
---

Firefox Tracking Flags

(firefox54 affected)

Details

(Reporter)

Description

8 months ago
Long queries in general may cause problems, and almost always there's a shorter and better way to handle the problem. Some sqlite APIs also have to do recursive work that may be really expensive on large queries.
We should probably use sqlite3_limit(db, SQLITE_LIMIT_SQL_LENGTH, 250000) or a smaller value.
But first we need to support binding arrays for IN clauses, so we can remove IN usage
(Reporter)

Updated

8 months ago
Priority: -- → P3
(Reporter)

Updated

8 months ago
Depends on: 483318
(Reporter)

Comment 1

8 months ago
note it would be nice to have telemetry about queries length, before doing this.
You need to log in before you can comment on or make changes to this bug.