print("{} rows {:1.4f}".format(qlen(c), end - start) +
"s\nFetching finished runs (vdv) ...")
start = time.time()
c, n = rundb.get_finished_runs(skip=0,
limit=50,
username="******",
success_only=False,
ltc_only=False)
end = time.time()
print("{} rows {:1.4f}".format(qlen(c), end - start) + "s\nRequesting pgn ...")
if n == 0:
c.append({"_id": "abc"})
start = time.time()
c = rundb.get_pgn(str(c[0]["_id"]) + ".pgn")
end = time.time()
# Tests: Explain some queries - should show which indexes are being used
print("{} rows {:1.4f}".format(qlen(c), end - start) + "s")
print("\n\nExplain queries")
print("\nFetching unfinished runs xp ...")
start = time.time()
c = runs.find({
"finished": False
},
sort=[("last_updated", DESCENDING),
("start_time", DESCENDING)]).explain()
print(pprint.pformat(c, indent=3, width=110))
end = time.time()
print(s)
sys.stdout.flush()
printout("\nFetching unfinished runs ...")
start = time.time()
unfinished_runs = rundb.get_unfinished_runs()
end = time.time()
printout(str(end-start) + "s\nFetching machines ...")
start = time.time()
machines = rundb.get_machines()
end = time.time()
printout(str(end-start) + "s\nFetching finished runs ...")
start = time.time()
finished, num_finished = rundb.get_finished_runs(skip=0, limit=50, username='',
success_only=False, ltc_only=False)
end = time.time()
printout(str(end-start) + "s\nRequesting pgn ...")
if (len(finished) == 0):
finished.append({'_id':'abc'})
start = time.time()
pgn = rundb.get_pgn(str(finished[0]['_id']) + ".pgn")
end = time.time()
printout(str(end-start) + "s\n")
start = time.time()
c, n = rundb.get_finished_runs(skip=0, limit=50, username='',
success_only=False, ltc_only=False)
end = time.time()
print("{} rows {:1.4f}".format(qlen(c), end-start) + "s\nFetching finished runs (vdv) ...")
start = time.time()
c, n = rundb.get_finished_runs(skip=0, limit=50, username='******',
success_only=False, ltc_only=False)
end = time.time()
print("{} rows {:1.4f}".format(qlen(c), end-start) + "s\nRequesting pgn ...")
if (n == 0):
c.append({'_id':'abc'})
start = time.time()
c = rundb.get_pgn(str(c[0]['_id']) + ".pgn")
end = time.time()
# Tests: Explain some queries - should show which indexes are being used
print("{} rows {:1.4f}".format(qlen(c), end-start) + "s")
print("\n\nExplain queries")
print("\nFetching unfinished runs xp ...")
start = time.time()
c = runs.find({'finished': False}, sort=[('last_updated', DESCENDING), ('start_time', DESCENDING)]).explain()
print(pprint.pformat(c, indent=3, width=110))
end = time.time()
print("{} rows {:1.4f}".format(qlen(c), end-start) + "s")
print("\nFetching machines xp ...")
