YouthMuzik
New Member
I have to store millions of URLs in a database, and be able to find rows by URL quickly.MySQL's string indexes aren't quick enough for this, because they only index the first 4 characters of the string, which are generally \[code\]www.\[/code\], and then MySQL iterates over each of those rows starting with \[code\]www.\[/code\] and compares the value with the URL I searched for.MongoDB doesn't let you customize how many characters are indexed for strings, and the docs aren't very detailed, so I don't think MongoDB is suitable.Google App Engine has a special URL type, which is great, but I can't use GAE.Any suggestions?