C# sqlite/NoSQL advise on choice

Question

SQL

Hello everyone,

tell me which implementation should I choose.
I need to save a lot of data.
But at the same time, everything should be saved in separate files.

whether to try sqlite or db4o.
I would like something in common between sqlite and mongoDB Thanks

in advance

Answer 1

Why is storage in separate files necessary? why files?

Answer 2

The fact is that the data then needs to be copied to another medium
, most often manually. Separate files are needed for different groups and months.

Answer 3

sqlite is one of the slowest implementations for writing (on an average win machine from 100ms per transaction), even ms access is faster, but reading is fast, plus high compatibility (if you need a separate file, then you need to transfer it from machine to machine? and sqlite is under ALL platforms)
nosql is generally difficult to compare with sql, the highest speed (an order of magnitude higher than sql), but key -> value creates restrictions, and makes sense mainly for document-oriented databases, i.e. if you have 1->m then you have to serialize the lists and take care of the integrity yourself.

Answer 4

Do you require further data sampling and analysis?
If not, then you should write directly to the file.