H2数据库与Android上的SQLite-H2DatabasevsSQLiteonAndroid

8  

Things are much better than I have expected. I now have an Android phone (HTC Desire, Android 2.2) and I made a first test.

事情比我预期的要好得多。我现在有一部Android手机（HTC Desire，Android 2.2），我做了第一次测试。

Opening and closing a database is relatively slow so far (opening an existing database for the second time takes 0.2 seconds, closing about 0.2 seconds), but otherwise it looks like H2 performs quite well on Android, even if the Dalvik VM is not yet as optimized as a desktop JVM. It's too early to give concrete numbers, but Android is now a supported platform.

到目前为止，打开和关闭数据库相对较慢（第二次打开现有数据库需要0.2秒，关闭大约0.2秒），但是否则看起来H2在Android上表现相当不错，即使Dalvik VM还没有优化为桌面JVM。现在提供具体数字还为时过早，但Android现在是一个受支持的平台。

3  

I would be also very interested in real-world performance tests for the H2 database on Android. I think that H2 will be a lot slower than SQLite, mainly because the virtual machine on Android is still not that great. This got better with Android 2.2, but I think there is still a big difference. My guess is that H2 is currently about 10 times slower. But that's only a guess.

我也对Android上的H2数据库的真实性能测试非常感兴趣。我认为H2会比SQLite慢很多，主要是因为Android上的虚拟机仍然不是那么好。这在Android 2.2中变得更好，但我认为仍然存在很大差异。我的猜测是H2目前慢了大约10倍。但这只是猜测。

About the Unicode problem: what about converting strings to UTF-8 before storing them in SQLite?

关于Unicode问题：在将字符串存储到SQLite之前将字符串转换为UTF-8怎么样？