MongoDB Fuzzy Query command

Command-line query:

1, you can use. * To fuzzy query, the following is the query surname Chen user.

Db.customers.find ({name:/Chen */i});

2, also can not carry * number

Db.fs.files.find ({filename:/install_mongo.sh/i})

PHP Query:

$query =array ("Name" =>newmongoregex ("/.*". $name. "). */i "));
$db->find ($query);

Simple tens of thousands of data does not matter, but more than 2 million data, the text field for fuzzy query, basic find out, how to improve query efficiency

Solutions

English is built full text index, Chinese well, hehe, want to find another Full-text indexing scheme to help, such as Elasticsearch

Can use Lucence/sphinx combine MongoDB to do search query, MongoDB query efficiency is indeed relatively low