[SQLiteJDBC] Why is this query answered instantly by the sqlite3 application, but slowly using sqlitejdbc? [MORE INFO]

Gary Helmstetter gh at theworld.com
Mon Mar 1 07:17:17 EST 2010


Earlier today, I wrote:
 > I'm using Mac OS X v10.4.11 with the standard Java (1.5.0_19) and  
sqlite3 (3.1.3) that came it. (Yeah, a little old.)

OK, so this weekend I upgraded to Mac OS X v10.5.8, Java 1.5.0_22,  
sqlite3 3.4.0, and sqlitejdbc v056.

No difference in performance; the sqlite3 app responds instantly, and  
the java program that uses sqlitejdbc takes 10 seconds to complete the  
same query.




More information about the SQLiteJDBC mailing list