mercredi 15 avril 2015

How do SQLite and UnQLite compare with read and write speeds?

I've researched on what I can about SQLite and UnQLite but there are still a few things that haven't quite been answered yet.


From all that I have seen the two have very few differences comparatively speaking, namely that SQLite is a relational database whereas UnQLite is a key-value pair and document (via Jx9) database. They're both portable, cross-platform, and 32/64-bit friendly, and can have single-write and multi-read connections. UnQLite looks like it was released within only a few years ago which would attribute to the lack of benchmarks, and performance comparisons may be somewhat apples-to-oranges here.


Very little can be found on UnQLite benchmarks while SQLite has quite a few with different implementations across various (scripting) languages. SQLite has some varied performance across in-memory databases, indexed data, and read/write modes with varying data size. Overall SQLite is quick and reliable.


Are there any performance results published that can help show UnQLite's performance to show how well the two stack up? All that I can find are unreliable and confusing.




If it helps at all to explain my intrigue, I'm developing a network utility that will be reading and processing packets with hot-swapping between network interfaces. Since the connections can, though unlikely, reach speeds up to 1 Gbps there will be a lot of raw data being written out to a database. It's still in the early stages of development and I'm having to find a way to balance out performance. There are a lot of factors such as missed packets, how large each write size is, how quickly it can process and move data, how much organization will be required, how many tables will be needed, if I can implement multiprocessing, how reliant each database is on HDD speeds, etc. etc.. My data will need tables but whether or not I have to store them as relational is still in the air. Seeing how the two stack up with their own pros and cons (aside from the usual KVP vs Relational debate) may push me towards either one or, if I'm crazy enough, a mix of both


Aucun commentaire:

Enregistrer un commentaire