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] In-memory DB slower than disk-based?

What is the system memory utilization? If the in-memory database overloads the real memory the frantic os virtual memory paging (thrashing) could slow everything down. >From your use scenario it sounds like your database shouldn't be that large, but how large is the database? and how large is the

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] In-memory DB slower than disk-based?

On 6 Aug 2014, at 11:00pm, big stone wrote: > I too noticed disappointing improvements by going ":memory:". > But, it seems also very dependent of the compilation options and the > version of SQLite you use. > > sometimes, gain is roughly 0% > sometimes, gain can be 40%.

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] In-memory DB slower than disk-based?

Hi, I too noticed disappointing improvements by going ":memory:". But, it seems also very dependent of the compilation options and the version of SQLite you use. sometimes, gain is roughly 0% sometimes, gain can be 40%. ==> You may try with a more recent version of SQLite than 3.7.15.2.

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] In-memory DB slower than disk-based?

Thanks for the replies, Fabian and Richard. It’s definitely ‘good enough’ performance as-is, I mainly wanted to see if I was doing something clearly wrong, or if my results were surprising. Given that they’re not, I’m happy to move on. Thanks again, -Vern IMPORTANT WARNING: This message is

Re: [sqlite] In-memory DB slower than disk-based?

On Wed, Aug 6, 2014 at 2:51 PM, Jensen, Vern wrote: > *bump* > > Anyone? > I don't think anybody has any information for you Vern. So much depends on the details of your setup that it is hard to speculate what might be going wrong. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] In-memory DB slower than disk-based?

On 8/6/2014 11:51 AM, Jensen, Vern wrote: *bump* Anyone? Not sure if this is your problem, but this kind of load puts a lot of stress on SQLite's page cache, which might well perform worse than your OS'es page cache (used for "real" disk IO) does, especially under high contention. Also,

Re: [sqlite] In-memory DB slower than disk-based?

*bump* Anyone? -Vern Vern Jensen Software Engineer Artificial Intelligence in Medicine (AIM) Program jens...@cshs.org Office: 310-423-8148 :: Fax: 310-423-0173 On Aug 4, 2014, at 12:02 PM, Jensen, Vern

Re: [sqlite] Problem with coalesce in a where clause with bind variables

On Wed, Aug 6, 2014 at 5:29 PM, Martin Engelschalk < engelsch...@codeswift.com> wrote: > Hello List, > > I have a strange problem with a statement like > > select id from some_table where coalesce(some_col, 1) = :1 > > where :1 is a bind variable which i bind in my program using >

Re: [sqlite] Problem with coalesce in a where clause with bind variables

On Wed, Aug 6, 2014 at 11:29 AM, Martin Engelschalk < engelsch...@codeswift.com> wrote: > Hello List, > > I have a strange problem with a statement like > > select id from some_table where coalesce(some_col, 1) = :1 > > where :1 is a bind variable which i bind in my program using >

[sqlite] Problem with coalesce in a where clause with bind variables

Hello List, I have a strange problem with a statement like select id from some_table where coalesce(some_col, 1) = :1 where :1 is a bind variable which i bind in my program using sqlite3_bind_text. I get no records, even if there are no null values anywhere in some_col. I get the

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 Support for CE x32 FW 3.5

Did you already read https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki#sqlite-netFx35-binary-PocketPC-ARM-2008 ? On Tue, Aug 5, 2014 at 10:32 AM, Tobias Stüker wrote: > Hello, > > I am developing an .NET Framework 3.5 application for a Windows CE

Re: [sqlite] Producing RFC4180-compliant CSV output

On 4 August 2014 16:39, Edward Lau wrote: > Specifically, if you are going to use SQL Server Integration Services (SSIS) > you can specify LF as the record delimiter. It defaults to {CR}{LF} but you > can change it in the FlatFile Connection Manager under the Advance tab.

Re: [sqlite] SQLite Support for CE x32 FW 3.5

Hello, I am developing a .NET Framework 3.5 application for a Windows CE 32bit (x86) PC. Can I get a Library of SQLite for that System? Best regards, Tobias Beckhoff Automation GmbH | Managing Director: Dipl. Phys. Hans Beckhoff, Arnold Beckhoff Registered office: Verl, Germany | Register

[sqlite] SQLite Support for CE x32 FW 3.5

Hello, I am developing an .NET Framework 3.5 application for a Windows CE x32 PC. Can I get a Library of SQLite for that System? Best regards, Tobias Stüker Beckhoff Automation GmbH | Managing Director: Dipl. Phys. Hans Beckhoff, Arnold Beckhoff Registered office: Verl, Germany | Register

[sqlite] Need Technical Support for Replicate SQLite with Oracle DB

Hi Team,                We are using SQLite as a Client DB which is Local and Oracle Db as a Server. We are trying to Copy SQLite DB to Oracle DB 11g Server (Replication).Is this Possible? If so Can we get the right steps for Replication. how to replicate SQLite? Thanks Suvathi

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

Re: [sqlite] [sqlite-dev] 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

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"