Re: [sqlite] SQLite Expert query execution speed

[Keith Medcalf]

First, are both using the same version of the SQLite3 engine?

Select sqlite_version(), sqlite_source_id();

Compiled with the same options?

Pragma compile_options;

Are they both using the same database file?

How do the query plan's compare -- I would expect that they are significantly 
different in order to see such a variance in query execution.

---
()  ascii ribbon campaign against html e-mail
/\  www.asciiribbon.org

> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Gert Corthout
> Sent: Friday, 10 August, 2012 06:03
> To: sqlite-users@sqlite.org
> Subject: [sqlite] SQLite Expert query execution speed
> 
> 
> hello,
> 
> we have noticed that executing a select query in SQLite expert is 3 times as
> fast as executing it using our own C++ application. This seems quite odd as
> we are doing no funky stuff in the code, the sqlite3_step alone in our app
> takes longer then the entire process in (compiling the query, executing it,
> and showing the results) does in SQLIte Expert.
> Does SQLite Expert do something special?
> 
> We use the following pragma's:
> Pragma encoding  = 'UTF-16'
> Pragma page_size = 4096
> PRAGMA foreign_keys = ON
> 
> thanks in advance,
> Gert
> 
> ___
> 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

[sqlite] SQLite Expert query execution speed

[Gert Corthout]

hello,

we have noticed that executing a select query in SQLite expert is 3 times as 
fast as executing it using our own C++ application. This seems quite odd as we 
are doing no funky stuff in the code, the sqlite3_step alone in our app takes 
longer then the entire process in (compiling the query, executing it, and 
showing the results) does in SQLIte Expert.
Does SQLite Expert do something special? 

We use the following pragma's:
Pragma encoding  = 'UTF-16'
Pragma page_size = 4096
PRAGMA foreign_keys = ON

thanks in advance,
Gert
  
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite Expert

[stefanos sofroniou]

It's one of the best programs I have tested myself. I have even suggested to 
Bogdan to add forms to make it even a better application for covering GUI needs 
for complex database like in my case where I have to deal with stock taking and 
cartridges. I hope he do something about it because honestly is one of the 
greatest applications I have ever tried on SQLite adminstration; highly 
recommended by all means.




>
>From: Don V Nielsen <donvniel...@gmail.com>
>To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
>Sent: Monday, October 31, 2011 11:05 PM
>Subject: Re: [sqlite] SQLite Expert
>
>I use the free version of sqlite expert.  I use sqlite for my IO handling.
>Having the power of sql available to test values, generate counts, etc...
>is indispensable.
>
>On Sun, Oct 30, 2011 at 2:50 PM, Abair Heart <abairhe...@gmail.com> wrote:
>
>> Hi all,
>>
>> Searching the archives implies, that "sqlite expert" hasn't been asked
>> about.
>>
>> Has anyone tried it yet?  Is the program safe? time-saving?
>>
>>
>> Thanks for any input.
>>
>> Abair
>> ___
>> 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
>
>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite Expert

[Don V Nielsen]

I use the free version of sqlite expert.  I use sqlite for my IO handling.
 Having the power of sql available to test values, generate counts, etc...
is indispensable.

On Sun, Oct 30, 2011 at 2:50 PM, Abair Heart  wrote:

> Hi all,
>
> Searching the archives implies, that "sqlite expert" hasn't been asked
> about.
>
> Has anyone tried it yet?  Is the program safe? time-saving?
>
>
> Thanks for any input.
>
> Abair
> ___
> 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] SQLite Expert

[Abair Heart]

Thanks for your answer, Jean-Christophe,

I'll give it a try.


Abair



> On Sun, 30 Oct 2011 22:41:58 +0100 Jean-Christophe Deschamps said:
>
> >On 30 Oct 2011, at 7:50pm, Abair Heart wrote:
> >
> > > Searching the archives implies, that "sqlite expert" hasn't been asked
> > > about.
> > >
> > > Has anyone tried it yet?  Is the program safe? time-saving?
> > ...
>
> As a long-term fan user of SQLite Expert, I can vouch it's one of the
> very best if not the best Windows-based SQLite manager.  I just can't
> live without and use it hourly.
>
> The program is not only "safe" (don't know what you meant here) but
> guaranteed free of any kind of nasties


that's what I meant.


> even in its freeware
> version.  It also uninstalls cleanly.
> ...
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite Expert

[Jean-Christophe Deschamps]

On 30 Oct 2011, at 7:50pm, Abair Heart wrote:

> Searching the archives implies, that "sqlite expert" hasn't been asked
> about.
>
> Has anyone tried it yet?  Is the program safe? time-saving?

Give me the $59 and a Windows computer and I'll check it out.

Simon.


As a long-term fan user of SQLite Expert, I can vouch it's one of the 
very best if not the best Windows-based SQLite manager.  I just can't 
live without and use it hourly.


The program is not only "safe" (don't know what you meant here) but 
guaranteed free of any kind of nasties even in its freeware 
version.  It also uninstalls cleanly.


Browse thru the release history and you'll see that the author is 
highly commited to following both SQLite evolution and what the users 
require or report.  Trust me: Bogdan fixes issues/bugs/requests faster 
than any open/closed, free/commercial product I know of.


As a disclaimer, I'll add that the author has become a friend over time 
and discussions about SQLite and Expert matters.


Nevertheless, my opinion is also factual and you can try it without 
fear.  I highly recommend to users getting any seriously into SQLite to 
consider switching to the paid version, just like what I did years 
ago.  It's easy to see why: say you value your time at, say, $15/hour, 
it only takes 4 hours saved to start paying back.  Given that the rich 
features it offers save you ample time very quickly, your investment is 
a winner.


For those not requiring the payware features, try the freeware version, 
no risk.


Don't ask: this isn't a shameless plug, I constantly stand behind what 
I say in full honesty. 


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite Expert

[Simon Slavin]

On 30 Oct 2011, at 7:50pm, Abair Heart wrote:

> Searching the archives implies, that "sqlite expert" hasn't been asked
> about.
> 
> Has anyone tried it yet?  Is the program safe? time-saving?

Give me the $59 and a Windows computer and I'll check it out.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite Expert

[Abair Heart]

Hi all,

Searching the archives implies, that "sqlite expert" hasn't been asked
about.

Has anyone tried it yet?  Is the program safe? time-saving?


Thanks for any input.

Abair
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users