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
On Wed, 6 Aug 2014 20:56:24 -0400
Richard Hipp d...@sqlite.org 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 southerners prefer to
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...
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
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 5,
Richard Hipp wrote:
On Wed, Aug 6, 2014 at 8:33 PM, James K. Lowden jklow...@schemamania.org
wrote:
On Wed, 6 Aug 2014 07:40:43 -0400
Richard Hipp d...@sqlite.org wrote:
PS: backward compatibility, no s, no?
A google search shows that you see it both ways - with and without the
On Thu, Aug 7, 2014 at 10:01 AM, E.Pasma pasm...@concepts.nl 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 latest
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 d...@sqlite.org wrote:
On Thu, Aug 7, 2014 at 10:01 AM, E.Pasma pasm...@concepts.nl wrote:
I have a case where a primary key index is no longer
On Wed, Aug 6, 2014 at 2:57 AM, Richard Hipp d...@sqlite.org 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
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
-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
Version 3.8.6
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;
On Wed, Aug 6, 2014 at 6:34 AM, Tony Papadimitriou to...@acm.org 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?
create table
On Wed, Aug 6, 2014 at 3:26 AM, Dominique Devienne ddevie...@gmail.com
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
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 September.
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 Hipp
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,
On Wed, Aug 6, 2014 at 5:35 PM, big stone stonebi...@gmail.com 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 recent in
On Wed, 6 Aug 2014 07:40:43 -0400
Richard Hipp d...@sqlite.org 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.
http://www.perfectyourenglish.com/vocabulary/backward-backwards.htm
Two
On Wed, Aug 6, 2014 at 8:33 PM, James K. Lowden jklow...@schemamania.org
wrote:
On Wed, 6 Aug 2014 07:40:43 -0400
Richard Hipp d...@sqlite.org 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
On Wed, Aug 6, 2014 at 6:56 PM, Richard Hipp d...@sqlite.org wrote:
On Wed, Aug 6, 2014 at 8:33 PM, James K. Lowden jklow...@schemamania.org
wrote:
On Wed, 6 Aug 2014 07:40:43 -0400
Richard Hipp d...@sqlite.org wrote:
PS: backward compatibility, no s, no?
A google
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
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
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.
24 matches
Mail list logo