The 15 seconds "smells" like a time out. I've found in the past where if the database being accessed is in read only mode (Either by filesystem permissions, or just the plain old READ ONLY file attribute) SQLite pauses. I can dupe this with using any utility, be it the SQLite CLI or PHP or SQLite Expert, etc. Changing the DB into something that is read-only locks it down. Try doing something to the database that needs a write and see if you get an error.
On Mon, Nov 4, 2013 at 6:12 AM, SongbookDB <shaun_thom...@songbookdb.com>wrote: > Thanks Clemens > > Flash gives the error - no such function: 'sqlite_version' > > SQLite Administrator says 3.5.1 > > I'll see what the Adobe community say. > > > > > On Mon, Nov 4, 2013 at 9:30 PM, Clemens Ladisch <clem...@ladisch.de> > wrote: > > > SongbookDB wrote: > > > The database has an index that is being used according to EXPLAIN QUERY > > > PLAN in SQLite Administrator. Does Flash use the same SQL code? > > > > Probably not. Try "SELECT sqlite_version();". > > > > > > Regards, > > Clemens > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > > -- > Shaun Thomson > Owner - SongbookDB > _______________________________________________ > 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
