[sqlite] SQLite and Java

Hi, I am using SQLite from within Java. Unfortunately, the Java wrapper linked from the SQLite website tends to be rather slow when returning large resultsets from a query. Has anybody a handy solution for / experiences with that? Thanks, Bo ---

[sqlite] java wrapper JDBC

Hallo, as just discovered with the help of this mailing list, the Java wrapper from http://www.ch-werner.de/javasqlite/ turned out to be a bit slow in returning large result sets. Does anybody know of another Java wrapper resp. JDBC driver for SQLite? Best, Bo --

Re: [sqlite] performance question

Thanks for the hint, Frank! It is indeed the Java wrapper which takes its time and it has nothing to do with SQLite itself. From the command line the query is done in a blink. So I have to find a workaround for the Java wrapper since I do not think there is another one out there. Thank you all

Re: [sqlite] performance question

Thanks! That decreased query time about 3 seconds in the first as well as the second (!) query. I suppose that the 50 extra seconds of the first query really have something to do with the initialization of the DB. Bo > On my PC the following query requires about 53 seconds: > > select *

[sqlite] performance question

Hi, I have a question about the performance of my SQLite DB, where the db-file has about 20MB and which I use in a Java application via the Java wrapper. This are the relevant parts of the scheme: create table TABB (B INTEGER,GB INTEGER,G,PRIMARY KEY(B,GB)); create table TABG (G INTEGER PRIMA

[sqlite] how to switch to asynchronous mode?

Hi, I just converted a DB from Oracle to SQLite and am now trying to improve the performance. On the performance comparison page of the sqlite.org website I read about an asynchronous mode, which performed faster in many cases. How can I switch SQLite to asynchronous mode? Thanks in advance,