Thanks for reply ! Executing "PRAGMA compile_options;"
My application: ENABLE_COLUMN_METADATA ENABLE_FTS3 ENABLE_FTS3_PARENTHESIS ENABLE_FTS4 ENABLE_FTS5 ENABLE_JSON1 ENABLE_RTREE ENABLE_STAT4 ENABLE_UNLOCK_NOTIFY HAS_CODEC OMIT_TCL_VARIABLE SOUNDEX SYSTEM_MALLOC THREADSAFE=1 sqlite3 application (shell): ENABLE_COLUMN_METADATA ENABLE_FTS3 ENABLE_FTS3_PARENTHESIS ENABLE_FTS4 ENABLE_FTS5 ENABLE_JSON1 ENABLE_RTREE ENABLE_STAT4 ENABLE_UNLOCK_NOTIFY HAS_CODEC HAVE_ISNAN SMALL_STACK SOUNDEX SYSTEM_MALLOC THREADSAFE=1 I do not see something significant here to justify sqlite3 using indexes and my application not using then. Cheers ! > Mon Apr 04 2016 10:59:17 AM CEST from "Simon Slavin" ><slavins at bigfraud.org> Subject: Re: [sqlite] Difference between sqlite3 >executable and application > > On 4 Apr 2016, at 9:53am, Domingo Alvarez Duarte ><sqlite-mail at dev.dadbiz.es> wrote: > > >>What compile time options if any can cause this ? >> > I recommend you compare the results of > > PRAGMA compile_options; > > on the two platforms. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > ?