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_autoindex_tbl_flex_template_1|10 1 zones|sqlite_autoindex_zones_1|84 6 1 history||5870 tbl_flex_content2|idx_flex_content_temp|20010 2001 tbl_flex_content2|idx_flex_content_owner|20010 10 tbl_library|idx_library_removed|1 1 tbl_library|sqlite_autoindex_tbl_library_1|1 1 tbl_lib_filters|sqlite_autoindex_tbl_lib_filters_1|4 1 tbl_filter_profiles|idx_filters2_library|4 4 tbl_filter_profiles|sqlite_autoindex_tbl_filter_profiles_1|4 1 category_item|sqlite_autoindex_category_item_1|6827 20 2 1 library_fts3_segdir|sqlite_autoindex_library_fts3_segdir_1|28 10 1 library_fts3_segments||254 infos||1293 tbl_groups||1 disks_bez|sqlite_autoindex_disks_bez_1|11 1 tbl_library_item|idx_library_item_fts3|2000 1 tbl_library_item|idx_library_item_removed|2000 2000 tbl_library_item|idx_library_item_lib|2000 2000 tbl_library_item|sqlite_autoindex_tbl_library_item_1|2000 1 category|sqlite_autoindex_category_1|416 1 library_fts3_content||2000 zone_bez|sqlite_autoindex_zone_bez_1|4 1 category_alias|sqlite_autoindex_category_alias_1|114 1 item_ref|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> > Betreff: Re: [sqlite] Long execution time since sqlite 3.8 > > On Tue, Jul 29, 2014 at 4:55 AM, Michael <ruther1...@gmx-topmail.de> 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-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
