SQLiteJDBC
<- | SQLiteJDBC | Changelog | Usage | Speed | Custom Functions | Javadoc
Speed
SQLite is fast. Java core is fast. JNI is fast. The result is thin libraries like SQLiteJDBC are also fast. Below are some numbers I made up to prove it.
You can make up these numbers yourself by downloading the source tarball and typing make speed.
More tests, comparisons and pretty graphs coming as I find the time.
Memory Database
| Fast Mac | Normal Linux | |
|---|---|---|
| 1000 Inserts (prep) | 9ms | 10ms |
| 1000 Inserts | 26ms | 27ms |
| With Transactions | ||
| 1000 Inserts (prep) | 7ms | 8ms |
| 1000 Inserts | 25ms | 25ms |
File database
| Fast Mac | Normal Linux | |
|---|---|---|
| With Transactions | ||
| 1000 Inserts (prep) | 20ms | 37ms |
| 1000 Inserts | 37ms | 53ms |
Systems
| Fast Mac | Black Macbook - Intel Core Duo 2ghz |
|---|---|
| Normal Liunx | AMD Duron 1.6ghz |
All have plenty of RAM.