最好的嵌入式SQL DB的写性能？ [英] Best Embedded SQL DB for write performance?

问题描述

有没有人对流行的开源嵌入式SQL数据库进行性能，特别是写性能的基准测试/评估？我有一些比较1：1比较sqlite，Firebird Embedded，Derby和HSQLDB（其他我缺少？），但没有进行全面的比较...另外，我会感兴趣的任何这些的总体开发人员经验对于一个Java应用程序）。

Has anybody done any benchmarking/evaluation of the popular open-source embedded SQL DBs for performance, particularly write performance? I've some 1:1 comparisons for sqlite, Firebird Embedded, Derby and HSQLDB (others I am missing?) but no across the board comparisons... Also, I'd be interested in the overall developer experience for any of these (for a Java app).

推荐答案

此 benchmark from db4o 可能会有所帮助。它包括JavaDB（建立在Derby之上），HSQLDB，SqlLite。

This benchmark from db4o might be helpful. It includes, JavaDB (Built on top of Derby), HSQLDB, SqlLite.

似乎HSQLDB胜过它的同行，特别是在写作时。 H2作为HSQLDB的后继，在优化，集群，事务隔离功能的读写中比HSQLDB更快。

It seems HSQLDB out-performs its counterparts, especially when writing is concerned. H2, as a successor of HSQLDB, is faster than HSQLDB in both read and write with optimizing, clustering, transaction isolation features.

这篇关于最好的嵌入式SQL DB的写性能？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！