> Reading from the harddrive is very slow. Why were you reading from harddrive with Mongo? Prefix indexing is the only kind of string indexing that Mongo does

> Reading from the harddrive is very slow. Why were you reading from harddrive with Mongo? Prefix indexing is the only kind of string indexing that Mongo does, but it does a pretty good job with it. You must have a pretty large dataset if it couldn't keep the index in memory. > It could be easily hit with a regex injection It should be pretty easy to regex-escape the search string. Easier than building a substring searching engine. > It couldn't handle artists with multiple names That sounds like a data format issue. What I'm getting at is that, while the prefix-only issue might have been enough to justify this switch, none of your other reasons make a ton of sense to me.