Re: [sqlite] Disparity between query time in SQLite Administrator and Flash Pro
Thanks Stephen - had a quick play with SQLite Expert just now before sleep - found a 3.7.4 dll and dropped it in and it loaded up fine. I'll see if the queries take the same time as in Flash tomorrow. On Thu, Nov 7, 2013 at 10:53 PM, Stephen Chrzanowskiwrote: > SQLite Expert allows you to use any SQLite DLL. Its free for > non-commercial use, but even that said, its an awesome package to buy, life > time upgrades, and seemingly always being updated. > > http://www.sqliteexpert.com/ > > > > On Wed, Nov 6, 2013 at 7:30 PM, SongbookDB >wrote: > > > Just got a reply re the version Flash uses - it's 3.7.4 RC4, which is > later > > than what SQLite Administrator uses (3.5.1). > > > > Is there a program like SQLite Administrator that will let me load a > > particular version of SQLite, so my testing will match the version in > Flash > > AIR? > > > > FYI - he used this to get the version from AIR - SELECT > sqlite_source_id() > > - and then looked the hash code returned up on the SQLite timeline at > > http://www.sqlite.org/cgi/src/info/a586a4deeb253300 > > > > > > On Thu, Nov 7, 2013 at 11:21 AM, Simon Slavin > > wrote: > > > > > > > > On 7 Nov 2013, at 12:09am, SongbookDB > > > wrote: > > > > > > > The database seems to write fine. I have it loading into a datagrid > in > > my > > > > Flash AIR desktop app, from where I read it and make edits to it. > > > > > > I don't understand how any SQLite app can return the error you gave: > > > > > > >> Flash gives the error - no such function: 'sqlite_version' > > > > > > All APIs that allow you to execute SQLite commands should let you > execute > > > > > > SELECT sqlite_version() > > > > > > so perhaps you have better ask the Flash Pro people about this problem. > > > > > > Simon. > > > ___ > > > 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 > -- Shaun Thomson Owner - SongbookDB ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Disparity between query time in SQLite Administrator and Flash Pro
SQLite Expert allows you to use any SQLite DLL. Its free for non-commercial use, but even that said, its an awesome package to buy, life time upgrades, and seemingly always being updated. http://www.sqliteexpert.com/ On Wed, Nov 6, 2013 at 7:30 PM, SongbookDBwrote: > Just got a reply re the version Flash uses - it's 3.7.4 RC4, which is later > than what SQLite Administrator uses (3.5.1). > > Is there a program like SQLite Administrator that will let me load a > particular version of SQLite, so my testing will match the version in Flash > AIR? > > FYI - he used this to get the version from AIR - SELECT sqlite_source_id() > - and then looked the hash code returned up on the SQLite timeline at > http://www.sqlite.org/cgi/src/info/a586a4deeb253300 > > > On Thu, Nov 7, 2013 at 11:21 AM, Simon Slavin > wrote: > > > > > On 7 Nov 2013, at 12:09am, SongbookDB > > wrote: > > > > > The database seems to write fine. I have it loading into a datagrid in > my > > > Flash AIR desktop app, from where I read it and make edits to it. > > > > I don't understand how any SQLite app can return the error you gave: > > > > >> Flash gives the error - no such function: 'sqlite_version' > > > > All APIs that allow you to execute SQLite commands should let you execute > > > > SELECT sqlite_version() > > > > so perhaps you have better ask the Flash Pro people about this problem. > > > > Simon. > > ___ > > 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
Re: [sqlite] Disparity between query time in SQLite Administrator and Flash Pro
Just got a reply re the version Flash uses - it's 3.7.4 RC4, which is later than what SQLite Administrator uses (3.5.1). Is there a program like SQLite Administrator that will let me load a particular version of SQLite, so my testing will match the version in Flash AIR? FYI - he used this to get the version from AIR - SELECT sqlite_source_id() - and then looked the hash code returned up on the SQLite timeline at http://www.sqlite.org/cgi/src/info/a586a4deeb253300 On Thu, Nov 7, 2013 at 11:21 AM, Simon Slavinwrote: > > On 7 Nov 2013, at 12:09am, SongbookDB > wrote: > > > The database seems to write fine. I have it loading into a datagrid in my > > Flash AIR desktop app, from where I read it and make edits to it. > > I don't understand how any SQLite app can return the error you gave: > > >> Flash gives the error - no such function: 'sqlite_version' > > All APIs that allow you to execute SQLite commands should let you execute > > SELECT sqlite_version() > > so perhaps you have better ask the Flash Pro people about this problem. > > Simon. > ___ > 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
Re: [sqlite] Disparity between query time in SQLite Administrator and Flash Pro
On 7 Nov 2013, at 12:09am, SongbookDBwrote: > The database seems to write fine. I have it loading into a datagrid in my > Flash AIR desktop app, from where I read it and make edits to it. I don't understand how any SQLite app can return the error you gave: >> Flash gives the error - no such function: 'sqlite_version' All APIs that allow you to execute SQLite commands should let you execute SELECT sqlite_version() so perhaps you have better ask the Flash Pro people about this problem. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Disparity between query time in SQLite Administrator and Flash Pro
Gidday Stephen The database seems to write fine. I have it loading into a datagrid in my Flash AIR desktop app, from where I read it and make edits to it. On Thu, Nov 7, 2013 at 2:54 AM, Stephen Chrzanowskiwrote: > 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 >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 > > 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 > -- Shaun Thomson Owner - SongbookDB ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Disparity between query time in SQLite Administrator and Flash Pro
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, SongbookDBwrote: > 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 > 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
Re: [sqlite] Disparity between query time in SQLite Administrator and Flash Pro
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 Ladischwrote: > 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
Re: [sqlite] Disparity between query time in SQLite Administrator and Flash Pro
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
[sqlite] Disparity between query time in SQLite Administrator and Flash Pro
Hi Just wondering if anyone has heard of Flash adding time to queries? I have a query that is taking almost 5 seconds on a database in Flash, yet when I put the same query into SQLite Administrator with that database loaded, it takes 15ms. I set up a flash timer, and start it just before... sqlStatement.execute(-1, new Responder( pass, fail )); ... and stop it and trace it as soon as Flash hits pass(); - so there's nothing else going on apart from the query to eat up time. The database has an index that is being used according to EXPLAIN QUERY PLAN in SQLite Administrator. Does Flash use the same SQL code? It's as if it's ignoring the index. Here's the query (I know there are a lot of COLLATE NOCASE statements - it's because my current table columns are not COLLATE NOCASE, and I'm not yet ready to set up a new table that has COLLATE NOCASE columns to copy the data into): SELECT * FROM (SELECT * FROM table1 WHERE col1 !="" COLLATE NOCASE ORDER BY col1 COLLATE NOCASE , col2 COLLATE NOCASE ASC, col3 COLLATE NOCASE ASC, col4 COLLATE NOCASE ASC ) UNION ALL SELECT * FROM (SELECT * FROM table1 WHERE col1="" COLLATE NOCASE ORDER BY col2 COLLATE NOCASE ASC, col3COLLATE NOCASE ASC, col4 COLLATE NOCASE ASC) LIMIT 10 Thanks for your thoughts. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users