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

[SongbookDB]

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

[Stephen Chrzanowski]

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

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

[SongbookDB]

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

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

[Simon Slavin]

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

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

[SongbookDB]

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

[Stephen Chrzanowski]

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

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

[SongbookDB]

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

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

[Clemens Ladisch]

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

[SongbookDB]

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