I came across UnQLite the other day in Stack OverflowStack Overflow and it has me intrigued for some software I'm working on. However, very few tests have been published on how well it performs. There are plentyThere are plenty of questionsquestions and public data available that help on SQLite and others but nothing on UnQLite. (I'm looking at serverless databases, hence my mention of SQLite. I understand that SQLite is relational whereas UnQLite is KVP and the two are not forked from the same parent projects)
I'd like to know:
- What UnQLite seems to achieve in read/write speeds
- What types of reads and writes (sequential, synchronous, large data, batch, random, etc.) it does well at compared to some other databases
- Where bottlenecking seems to occur
- How large the database tends to get (disk size or rows) before the time it takes to find and extract data begins to see a significant increase (i.e. slows down)
- If at all possible, what disk format(s) (ext3/4, NTFS, exFAT, HFS+) cause problems for the database
- Any recommended ways of optimizing performance with it
Thank you.