Re: [sqlite] SQLite Expert query execution speed
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
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
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 >To: General Discussion of SQLite Database >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 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
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
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
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
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
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