Skip to main content

Free embedded databases for C# (.Net) performance overview

I have tested several open-source embedded DB engines for .Net to find which one is the best for my purposes.
My choice for testing was:
Test application I wrote does following actions (and measure consumed time):
  1. Prepare DB: Recreate DB & tables (3 tables, 2 non-PK indexes)
  2. Create DB: Insert ~500 records to the DB
  3. Read All: sequentially read 400 records from the only table (no joins)
  4. Read Random: read random 400 records from the only table (no joins)
  5. Read / Write All: sequentially read & update 400 records from the only table (no joins)
  6. Read / Write Random: read & update random 400 records from the only table (no joins)
Results you may see here. FireBird is ~30 times slower on read operations than SQLite but 10-20 times faster on write operations. Overall time wins FireBird. It is 7 times faster.
As for SQLite .Net adapters System.Data.DQLite is faster then sqlite-net for ~ 1.4 times.
Final DB size: 912KB for FireBird, 40KB for SQLite.
I like sqlite-net framework style but current version is slow and does not support blobs & nullable types. I hope it will improve.

If you think I should test something else please comment.
Labels:

Comments

Post a Comment

Popular posts from this blog

Automated currency conversion in text

I have created a js script to automatically convert currency on page according to the current rate. Lets say I write "$5" and want to show its value in other currencies. I just need to enclose it in a tag with class = "exchange" and voila: $5 . To enable this behavior you need to link jQuery (add <script src="https://code.jquery.com/jquery-2.1.4.min.js" type="text/javascript"></script> to the head of page) and the script itself (add <script src="https://drclnatj7kvk6.cloudfront.net/currency.js" type="text/javascript"></script> to the bottom of the page). Script is based on http://fixer.io/ and http://openexchangerates.github.io/money.js/ . Fiddle is available here:  https://jsfiddle.net/40rr05fb/42/embedded/result/ . Language and displaying currencies can be easily set. Extending the script is also straightforward. If you dont see the magic, its Google Blogger's issue. Go into the arti...
2 comments
Read more

Choose free online software project tools

I spent a lot of time to choose high-quality online software project tools for free . Some of them are not so "free" other ones have a lot of ads or have low quality. Trying different solutions I chose following: Instant public chat : there is an options. You may create IRC channel on efnet.org or maintain public chat with Skype (BTW Skype supports up to 150 chat members now). Collaborative documents authoring : Google Docs have no competitors in this area. FAQ service : personally I prefer bravenet 's one. Mail list / discussion group : again Google Groups is the best one. Project management : unfortunately I was unable to find any wholly satisfactory project management online service. If you know one please let me know.
Post a Comment
Read more

Solving MSB6003 Error for ASP.NET Core Docker Image Build

Trying to build a Linux Docker image for ASP.NET Core project with Typescript support leads to a build error "MSB6003: The specified task executable "node" could not be run". The reason is Linux. On Windows, Microsoft.TypeScript.MSBuild includes tsc.exe. On non-Windows platforms, such as in a Docker container, Microsoft.TypeScript.MSBuild does not include ts.exe and instead shells out to a Node for the TypeScript compiler. The official dotnet/sdk Docker images I think included Node at one point in the past, but they no longer include Node. You will either need to make or find a Docker image with both the dotnet-sdk and Node, or configure some multi-stage build involving the official Node image [ 1 ]. Ok, if I know the reason then I will solve it in a minute. I thought. It turned out to be a quest to install the actual version of Node. Official Microsoft's image for dotnet is based on Debian (12 at the moment for .NET 8.0). So, the straight forward way would be u...
Post a Comment
Read more