MySQL table with couple of fields:
id
-PRIMARY KEY
url
-CHAR(255)
.
url
field is also unique and indexed. Currently have couple of hundreds of thousands entries in that table. MySQL gets really slow.
The idea is: if I add hash BIGINT UNIQUE INDEXED
field, and create composite index hash/url
- will it work faster? Means will MySQL first check my hash/url
pair using hash
and then url
? Will it be faster?
If answer is yes - for what reason this is not transparently implemented for indexed strings in MySQL?