Closed Bug 1792332 Opened 3 years ago Closed 3 years ago

URL bar queries take a long time (1.7s) to execute with max_pages = 999999

Categories

(Toolkit :: Places, defect)

Product:
Toolkit
Component:
Places
Type:
defect

Tracking

()

Status:
RESOLVED DUPLICATE of bug 1340487

People

(Reporter: jrmuizel, Unassigned)

Details

I have places.history.expiration.max_pages = 999999 so my situation might be a bit unusual but this seems to take a long time.

https://share.firefox.dev/3UGphA2

PLACES_AUTOCOMPLETE_1ST_RESULT_TIME_MS = 1.7s
PLACES_AUTOCOMPLETE_6_FIRST_RESULTS_TIME_MS = 1.8s

My places.sqlite is 360M

time cat places.sqlite   > /dev/null

real	0m0.055s
user	0m0.002s
sys	0m0.052s

The severity field is not set for this bug.
:mak, could you have a look please?

For more information, please visit auto_nag documentation.

Flags: needinfo?(mak)

The problem is we don't support infinite history, thus setting max_pages so high is pretty much asking for performance problems. That's the main reason we have a limit in first stance.
Long term the problem can be technically resolved, but there's no short term plan for it.

Status: NEW → RESOLVED
Closed: 3 years ago
Flags: needinfo?(mak)
Resolution: --- → DUPLICATE
You need to log in before you can comment on or make changes to this bug.