Closed Bug 701416 Opened 13 years ago Closed 13 years ago

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

Categories

(Pancake Graveyard :: Back-end, defect)

Product:
Pancake Graveyard
Component:
Back-end
Platform:
x86
macOS
Type:
defect
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: oyiptong, Unassigned)

Details

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.
Summary: Unindexed uri column in places causes slow queries for inserts → MySQL: Unindexed uri column in places causes slow queries for inserts
Status: NEW → ASSIGNED
Status: ASSIGNED → RESOLVED
Closed: 13 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.