mongo 添加两个字段索引值和非索引单条数据时间对比

# 链接mongo
import os
import time

import yaml
from bson import ObjectId
from pymongo import MongoClient, ASCENDING

parent_path = os.path.abspath(os.getcwd())
print('parent_path', parent_path)
yaml_data = open(os.path.join(parent_path, 'config.yaml'))
yaml_data = yaml.load(yaml_data)
mongo_url = yaml_data.get('mongo')
database = yaml_data.get('database')
print('mongo_url', mongo_url)
#链接mongo
client = MongoClient(host=mongo_url)
db = client[database]
print('db', db)
n = 0
# 数据库索引和无索引的情况单条数据时间对比
# for i in range(100):
print(f'数据加载{n}')
start_time = time.time()
db['users'].find_one({'uid': 20440, 'phone': "18310683630"})
print('数据库不加索引时间查询', time.time() - start_time)

# mongo 系统自带索引和 添加索引单条数据时间对比
# 添加索引
# user_index = db["users"].create_index([("uid", ASCENDING), ('phone', ASCENDING)])
# print('user_index', user_index)

start_time = time.time()
db["users"].find_one({'uid': 20440, 'phone': "18310683630"})

print('使用添加索引时间查询', time.time() - start_time)
# n+=1