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

et it too. > > Pavel > > On Thu, Sep 24, 2009 at 11:24 PM, George Bills wrote: > >> 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 writi

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

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 basi

Re: [sqlite] Sqlite profiler

On 09/23/2009 11:16 PM, mcnamaragio wrote: > Hello, > > Would anyone be interested in sqlite profiler? If yes what features would > you expect from it? > > Thank you. > Yes, I would be interested. A high level breakdown of what SQLite is doing, and the time it's taking to do it would be useful

[sqlite] Undesired query plan when using GROUP BY

Hi all, I was wondering if someone here could help me with understanding / solving an sqlite problem I'm having. Any help would be appreciated. =SCHEMA= CREATE TABLE pop_words_wpk ( word_id INTEGER PRIMARY KEY, occurrences INTEGER ); CREATE INDEX pop_words_wpk_oidx ON pop_words_wpk(occur