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 Chrzanowski wrote: > SQLite

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, SongbookDB

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

Re: [sqlite] Disparity between query time in SQLite Administrator and Flash Pro

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: >>

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 Chrzanowski wrote: > The 15 seconds "smells" like a time out. I've found in

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

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 Ladisch wrote: > SongbookDB wrote: > > The database has an index that is being used

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] 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...