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 Expert allows you to use a
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
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
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 f
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 the past where if
> the
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
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
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
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...
sq
9 matches
Mail list logo
