Does mongo have fast case-insensitive searches?

Question

MongoDB

Now if you use the isp: /^Vodafone India$/i regular expression in the query, then the query is executed for 60 seconds.
A direct match of isp: "Vodafone India" search is case-sensitive.

Answer 1

try like this:

db.coll.find({ $where: "this.isp.toLowerCase() === 'Vodafone India'.toLowerCase()" })

Answer 2

In version 2.4, full-text search appeared (though only 1 index per collection).
It works very fast in my opinion.