# 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.

2006-08-10