MySQL: Unindexed uri column in places causes slow queries for inserts

RESOLVED FIXED in M1

Status

Pancake
Back-end
RESOLVED FIXED
6 years ago
6 years ago

People

(Reporter: oyiptong, Unassigned)

Tracking

Details

(Reporter)

Description

6 years ago
The problem occurs when a user visits a site.

A query is placed to find if that user visited the site before, with the uri as a parameter.
Since that column is unindexed, this takes a long time if the table is large.

The solution is to either index that table or put a unique constraint on the uri. Option #2 seems more like it, as it will also have the effect of indexing the column.
(Reporter)

Updated

6 years ago
Summary: Unindexed uri column in places causes slow queries for inserts → MySQL: Unindexed uri column in places causes slow queries for inserts
(Reporter)

Updated

6 years ago
Status: NEW → ASSIGNED
(Reporter)

Updated

6 years ago
Status: ASSIGNED → RESOLVED
Last Resolved: 6 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.