Has open source software ever created a single file database that automatically processes transactions?

Question

Has open source code ever created a separate file database that has better performance when processing large sets of sql queries that are not supplied in formal SQL transaction sets? I am working with a .NET server that does some heavy replication of thousands of rows of data from another server, and does it on a 1 to 1 basis without formal SQL transactions. Therefore, I cannot use SQLite or FirebirdDB or JavaDB because they all do not automatically transfer transactions, and therefore performance is grim. Each insert is waiting for the success of the previous one, etc. So I have to use a heavier database like SQLServer, MySQL, Postgres or Oracle.

Does anyone know of a flat file database (with a JDBC connection driver) that will support automatic package transactions and solve my problem?

The main thing that I don’t like in heavier databases is the inability to see inside the database using the one-click operation, as you can with SQLLite.

I tried to create a SQLite database and then set PRAGMA read_uncommitted = TRUE; and this did not lead to improved performance.

Answer 1

I think Firebird might work for this.

Firebird has a good dotnet provider and many replication solutions

, Firebird

Answer 2

- http://hsqldb.org/doc/guide/ch02.html#N104FC

Answer 3

, (.. ), ( - ).

, RAID- SSD, .

The only way to avoid this is to somehow disable the flash while fixing txn (which, of course, breaks through durability). I don’t know which of them support this, but it should be easy to find out.