问题描述
有没有人对流行的开源嵌入式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).
推荐答案
此可能会有所帮助。它包括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的写性能?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!