Re: [sqlite] SQLite JDBC - org.sqlite.NativeDB.step taking up too much time

2009-09-27 Thread George Bills
This makes a lot of sense now - I haven't read up on the C interface and assumed that "step" was a JDBC thing. Thanks for clearing that up. George. On 09/26/2009 01:01 AM, Pavel Ivanov wrote: >> Does anyone know why this method might be so expensive? >> > Because it's main method to

Re: [sqlite] SQLite JDBC - org.sqlite.NativeDB.step taking up too much time

2009-09-25 Thread Pavel Ivanov
> Does anyone know why this method might be so expensive? Because it's main method to execute your queries. I believe I can safely assume that org.sqlite.NativeDB.step maps directly to C call sqlite3_step() and it's the only function where query is executed. It doesn't just iterate through

[sqlite] SQLite JDBC - org.sqlite.NativeDB.step taking up too much time

2009-09-24 Thread George Bills
Hi everyone - this might be a general JDBC question rather than an SQLite specific question, but I'm not sure. I've got an app that's writing to an SQLite database using the latest SQLite JDBC driver ("v056, based on SQLite 3.6.14.2") from http://www.zentus.com/sqlitejdbc/. I've done some