tstack/SqliteJdbcNG — pull request #10 by aaime (2013-10-14 18:07:35+00:00)
Title: Reify most frequently used read methods to speed up data reading

This changeset applies reification (http://code.google.com/p/jnaerator/wiki/Reification#Maximum_Performance_(w/_BridJ)) to the most frequently used read methods to get a solid speedup in read operations.
The speedup is significant, a read test pulling 67k records 10 times in a row went down from 7s to 5s on my machine, the cost is a less type safety.

Ah, in a couple of places I used a deprecated Pointer factory method, but I'm not sure which non deprecated method to use.. according to the sqlite documentation, the blobs and the strings returned by the sqlite3_column_* method should not be deallocated, as that happens automatically (see http://www.sqlite.org/c3ref/column_blob.html, torwards the end, "The pointers returned are valid until a type conversion occurs as described above, or until sqlite3_step() or sqlite3_reset() or sqlite3_finalize() is called. The memory space used to hold strings and BLOBs is freed automatically. Do not pass the pointers returned sqlite3_column_blob(), sqlite3_column_text(), etc. into sqlite3_free().")