increasingly slow searches #49
Description
I've run into an issue where searching gets slower over time. I know I may be pushing this TinyDB to it's performance limits. I have a database of around 10k dicts. Each Dict has five items.
So, Here is some psuedo code
class tiny_db():
def __init__(self):
self.db = TinyDB('db.json')
self.table = self.db.table('_default', smart_cache=True)
def file(self, item):
self.table.insert(item)
def locate(name)
result = self.table.search(where('name') == name)
return result
Every time I call tiny_db.locate(name) it takes 1 second longer than it did the last time I called. it.
I am probably doing something horribly wrong, Im not entirely sure how the caching middleware works, my grasp of python is pretty weak.
My duct tape fix has been to copy the db into a variable when my class initializes. I'm using that to search. But, I have to insert new items into both. I feel like there may be a better solution.
Sorry for the amateurish question, but thanks in advance.