本文介绍了最好的嵌入式SQL DB的写性能?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

有没有人对流行的开源嵌入式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的写性能?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

10-17 00:35