Re: [sqlite] Long execution time since sqlite 3.8

Uhr > *Von:* Michael <ruther1...@gmx-topmail.de> > *An:* sqlite-users@sqlite.org > *Betreff:* Re: [sqlite] Long execution time since sqlite 3.8 > CREATE TABLE android_metadata (locale TEXT); > CREATE TABLE tbl_lib_filters(UUID TEXT NOT NULL PRIMARY KEY, template > TEXT NOT NULL, l

Re: [sqlite] Long execution time since sqlite 3.8

I have attempted to reformat your query to make it more readable. Did I translate it correctly? CREATE TABLE infos( idINTEGER PRIMARY KEY, name TEXT, text TEXT, zone INTEGER DEFAULT 3, dateAdded DATATIME, lastModified DATETIME, votes

Re: [sqlite] Long execution time since sqlite 3.8

l <ruther1...@gmx-topmail.de> *An:* sqlite-users@sqlite.org *Betreff:* Re: [sqlite] Long execution time since sqlite 3.8 CREATE TABLE android_metadata (locale TEXT); CREATE TABLE tbl_lib_filters(UUID TEXT NOT NULL PRIMARY KEY, template TEXT NOT NULL, library TEXT NOT NULL, rules TEXT); CREATE TABLE

Re: [sqlite] Long execution time since sqlite 3.8

> An: sqlite-users@sqlite.org > Betreff: Re: [sqlite] Long execution time since sqlite 3.8 > > Ok that's the output of sqlite_stat1: > > tbl|idx|stat > android_metadata||1 > tbl_flex_template|idx_flex_template_lib|10 10 > tbl_flex_template|sqlite_aut

Re: [sqlite] Long execution time since sqlite 3.8

|sqlite_autoindex_item_ref_1|93 2 2 1 1 links|sqlite_autoindex_links_1|2762 2 and the schema attached > Gesendet: Dienstag, 29. Juli 2014 um 12:52 Uhr > Von: "Richard Hipp" <d...@sqlite.org> > An: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> > Bet

Re: [sqlite] Long execution time since sqlite 3.8

On Tue, Jul 29, 2014 at 4:55 AM, Michael wrote: > > Should I post the EXPLAIN? > No. You should post the database schema and the content of the sqlite_stat1, sqlite_stat3, and/or sqlite_stat4 tables if such tables exist. -- D. Richard Hipp d...@sqlite.org

[sqlite] Long execution time since sqlite 3.8

Hello, The following query needs about 8 seconds since 3.8. In sqlite-3.7.17 it was less than a second. select infos.name, infos.id, infos.rating, DateTime(infos.date), DateTime(infos.expiration) from infos where infos.id not in ( select distinct infos.id from infos, category,