search

neonrust / epm

Command-line TV episode calendar/manager/scheduler/tracker (EPisode Manager)
MIT License
0 stars 0 forks source link

Split database into "active" and "archived"? #17

Closed neonrust closed 7 months ago

neonrust commented 1 year ago

As the database grows, it makes sense to move the non-changing entries (i.e. the archived) into a separate database file. This will make it more awkward to perform the "all" listings. Not by a lot though.

neonrust commented 1 year ago

However, slow reading/writing the database probably doesn't become an issue until the database has at least a 1000 series in it (depends on how big they are, of course).

On my machine (i5-8400), at ~160 entries (4.5 MiB), it takes ~25ms (read) and ~120ms (write). (and my CPU is arguably on the low-end of things)

neonrust commented 7 months ago

This has been solved in practice, by separating data and meta data, in #44.