for i in range(0, 2000): SearchResult.create(indexer=indexers[x - 1], title="%s%d" % (rndstr(80), i), guid="%s%d" % (rndstr(100), i), link="%s%d" % (rndstr(120), i)) #SearchResult.create(indexer=indexers[x - 1], title="%s" % i, guid="%s" % i, link="%s" % i) after = time.time() print(after - now) now = time.time() rows = [] with database.db.atomic(): for i in range(0, 100): for x in range(1, 6): SearchResult.create_or_get(indexer=indexers[x - 1], title="%s%d" % (rndstr(80), i), guid="%s%d" % (rndstr(100), i), link="%s%d" % (rndstr(120), i)) #SearchResult.get_or_create(indexer=indexers[x - 1], title="%s%d" % (rndstr(80), i), guid="%s%d" % (rndstr(100), i), link="%s%d" % (rndstr(120), i)) #_, created = SearchResult.create_or_get(indexer=indexers[x - 1], title="%s" % i, guid="%s" % i, link="%s" % i) #print(created) after = time.time() print(after - now) # now = time.time() # rows = [] # with database.db.atomic(): # for i in range(0, 100): # for x in range(1, 6): # _, created = SearchResult.get_or_create(indexer=indexers[x - 1], title="%s" % i, guid="%s" % i, link="%s" % i) # print(created)