[sqlite] Is it possible that dropping a big table takes very long

[Cecil Westerhof]

2016-04-16 14:51 GMT+02:00 Simon Slavin <slavins at bigfraud.org>:

>
> On 16 Apr 2016, at 10:59am, Cecil Westerhof <cldwesterhof at gmail.com>
> wrote:
>
> > I first had a table with 1E8 elements. When
> > trying to drop this it looked like SQLite got hung.
>
> Please tell us which version of SQLite and which journal mode you're using.
>

?I work with Java. With:
    SELECT SQLITE_VERSION()
I get:
    3.8.11?


?How can I get the journal mode in Jav??
With DB Browser I get Delete.
But when I in sqlite3 give:
    PRAGMA schema.journal_mode;
I get:
    Error: unknown database schema

-- 
Cecil Westerhof