mongodb 设置索引的问题

Question

请问如何在mongodb 设置索引查询更快呢？

 def open_spider(self, spider):
        self.Client = pymongo.MongoClient(self.MongodbHost, self.MongodbPort)
        self.Mongodb = self.Client[self.MongodbName]
        self.db = self.Mongodb[self.MongodbCollection]

    def process_item(self, item, spider):

        unique_charcter = re.findall('https://files.zsxq.com/(.*?)\?attname', item['file_url'])[0]

        key_word = {"unique_charcter": unique_charcter, "name": item['name']}
        res = self.db.find(key_word)

        if len(list(res)) == 1:

            raise DropItem("Duplicate item found: %s" % item)
        else:

            self.db.insert({"unique_charcter": unique_charcter, "name": item['name']})

            return item

    def close_spider(self, spider):
        self.Client.close()
        
        

现在find() 没有加索引，我现在想查询更快，加索引怎么写？

Answer 1

针对你的查询应该是：

db.<collection>.createIndex({unique_charcter: 1, name: 1})