Re: [sqlite] SQLite version 3.8.6 coming soon

"big stone" wrote... hi Jose, The SQL request with a "in()" that is improved by 5x in the latest beta is of form : select * from a , b where a.field1 in (b.column1, b.column2, b.column3, b.column4, 'fixed value') Hi Big Stone, This is what I am running with an ATTACHed DB as client...

Re: [sqlite] SQLite version 3.8.6 coming soon

On Wed, 6 Aug 2014 20:56:24 -0400 Richard Hipp wrote: > > http://www.perfectyourenglish.com/vocabulary/backward-backwards.htm > > > > Two countries divided by a common tongue. > > > Except, I speak Southern English, not British English. And I can > promise you that we

Re: [sqlite] SQLite version 3.8.6 coming soon

hi Jose, The SQL request with a "in()" that is improved by 5x in the latest beta is of form : select * from a , b where a.field1 in (b.column1, b.column2, b.column3, b.column4, 'fixed value') ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] SQLite version 3.8.6 coming soon

FWIW, the Zumero test suite is fairly abusive and it passes all test cases with 3.8.6 beta. -- E On Thu, Aug 7, 2014 at 11:59 AM, Richard Hipp wrote: > On Thu, Aug 7, 2014 at 10:01 AM, E.Pasma wrote: > > > I have a case where a primary key index is no

Re: [sqlite] SQLite version 3.8.6 coming soon

On Thu, Aug 7, 2014 at 10:01 AM, E.Pasma wrote: > I have a case where a primary key index is no longer used where it was > used before. > Thank you for the test case! This problem should now be addressed on trunk and in the pre-release snapshots. Please retry using the

Re: [sqlite] SQLite version 3.8.6 coming soon

Richard Hipp wrote: > On Wed, Aug 6, 2014 at 8:33 PM, James K. Lowden > wrote: > >> On Wed, 6 Aug 2014 07:40:43 -0400 >> Richard Hipp wrote: >> >> > > >> > > PS: backward compatibility, no s, no? >> > > >> > >> > A google search shows that you see it

Re: [sqlite] SQLite version 3.8.6 coming soon

"Richard Hipp" wrote... 32-bit and 64-bit DLLs are the latest 3.8.6 beta are now available on the download page. http://www.sqlite.org/download.html All works great. No visible speed increase for WHERE .. IN () as reported by someone, but nonetheless, all is well. Thanks. On Tue, Aug

Re: [sqlite] SQLite version 3.8.6 coming soon

Op 6 aug 2014, om 02:57 heeft Richard Hipp het volgende geschreven: Version 3.8.6 was originally scheduled for September. But the change log ( http://www.sqlite.org/draft/releaselog/current.html) is getting rather long and there are a number of important bug fixes. So we might try to get

Re: [sqlite] SQLite version 3.8.6 coming soon

ok, output comparison Size is different : - before28 488 559 - now with beta 28 711 111 ==> delta = 222 552 ... which is my number of ouput lines The change in Newline Output policy (from CR to CR+LF) did generate a suspens. WinMerge says output is identical otherwise. So my 5x

Re: [sqlite] SQLite version 3.8.6 coming soon

On Wed, Aug 6, 2014 at 6:56 PM, Richard Hipp wrote: > On Wed, Aug 6, 2014 at 8:33 PM, James K. Lowden > wrote: > > > On Wed, 6 Aug 2014 07:40:43 -0400 > > Richard Hipp wrote: > > > > > > > > > > PS: backward compatibility, no s, no? >

Re: [sqlite] SQLite version 3.8.6 coming soon

On Wed, Aug 6, 2014 at 8:33 PM, James K. Lowden wrote: > On Wed, 6 Aug 2014 07:40:43 -0400 > Richard Hipp wrote: > > > > > > > PS: backward compatibility, no s, no? > > > > > > > A google search shows that you see it both ways - with and without the >

Re: [sqlite] SQLite version 3.8.6 coming soon

On Wed, 6 Aug 2014 07:40:43 -0400 Richard Hipp wrote: > > > > PS: backward compatibility, no s, no? > > > > A google search shows that you see it both ways - with and without the > "s". I've always used the "s".

Re: [sqlite] SQLite version 3.8.6 coming soon

On Wed, Aug 6, 2014 at 5:35 PM, big stone wrote: > Hello Sqlite team, > > My specific need relies on a rather complex combination of "in", and with > the new beta I go from 50 seconds down to 10 seconds. > (a 5x improvement) > > ==> Is that sort of gain possible with the

Re: [sqlite] SQLite version 3.8.6 coming soon

Hello Sqlite team, My specific need relies on a rather complex combination of "in", and with the new beta I go from 50 seconds down to 10 seconds. (a 5x improvement) ==> Is that sort of gain possible with the recent "in" omtimisation, or shall look deeper if result is still right ? Regards,

Re: [sqlite] SQLite version 3.8.6 coming soon

"Richard Hipp" wrote... 32-bit and 64-bit DLLs are the latest 3.8.6 beta are now available on the download page. http://www.sqlite.org/download.html Thank you very much, Dr. Hipp. josé On Tue, Aug 5, 2014 at 11:11 PM, jose isaias cabrera < jic...@cinops.xerox.com> wrote: "Richard

Re: [sqlite] SQLite version 3.8.6 coming soon

32-bit and 64-bit DLLs are the latest 3.8.6 beta are now available on the download page. http://www.sqlite.org/download.html On Tue, Aug 5, 2014 at 11:11 PM, jose isaias cabrera < jic...@cinops.xerox.com> wrote: > > "Richard Hipp" wrote... > > > Version 3.8.6 was originally scheduled for

Re: [sqlite] SQLite version 3.8.6 coming soon

On Wed, Aug 6, 2014 at 3:26 AM, Dominique Devienne wrote: > > PS: backward compatibility, no s, no? > A google search shows that you see it both ways - with and without the "s". I've always used the "s". -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] SQLite version 3.8.6 coming soon

On Wed, Aug 6, 2014 at 6:34 AM, Tony Papadimitriou wrote: > Unless I'm misusing it, I believe the shell readfile() function reads a > file as text, not binary. I haven't checked writefile() for the same > problem on writing. > > This is how I use it, is this not correct? > >

Re: [sqlite] SQLite version 3.8.6 coming soon

Unless I'm misusing it, I believe the shell readfile() function reads a file as text, not binary. I haven't checked writefile() for the same problem on writing. This is how I use it, is this not correct? create table t1(a blob); insert into t1 values(readfile('binfile')); select * from t1;

Re: [sqlite] SQLite version 3.8.6 coming soon

> -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Richard Hipp > Sent: 06 August 2014 01:58 > To: General Discussion of SQLite Database; sqlite-dev > Subject: [sqlite] SQLite version 3.8.6 coming soon

Re: [sqlite] SQLite version 3.8.6 coming soon

src/func.c: The comment on top refers to sqliteRegisterBuildinFunctions() but the actual call seems to have been renamed to sqliteRegisterGlobalFunctions() ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] SQLite version 3.8.6 coming soon

On Wed, Aug 6, 2014 at 2:57 AM, Richard Hipp wrote: > > Please review the change log and speak up if you see anything amiss. The new doc mentioned by http://www.sqlite.org/draft/lang_expr.html#hexint may have a 1-char typo: However, for backwards compatibility, the "Ox"

Re: [sqlite] SQLite version 3.8.6 coming soon

"Richard Hipp" wrote... Version 3.8.6 was originally scheduled for September. But the change log ( http://www.sqlite.org/draft/releaselog/current.html) is getting rather long and there are a number of important bug fixes. So we might try to get 3.8.6 out the door sooner rather than later.

[sqlite] SQLite version 3.8.6 coming soon

Version 3.8.6 was originally scheduled for September. But the change log ( http://www.sqlite.org/draft/releaselog/current.html) is getting rather long and there are a number of important bug fixes. So we might try to get 3.8.6 out the door sooner rather than later. Please test! Recent