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: 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.