Re: [sqlite] Potential problem in SQLite 3.7.16.2

Thank you for providing this pre-release amalgamation ;-) I downloaded it immediately and compiled it into my software. The problem has been ++resolved++ and the performance is at least as good as with previous versions of SQLite. It even feels a bit faster, although I only could try it with a

Re: [sqlite] Potential problem in SQLite 3.7.16.2

Thank you for providing this pre-release amalgamation ;-) I downloaded it immediately and compiled it into my software. The problem has been ++resolved++ and the performance is at least as good as with previous versions of SQLite. It even feels a bit faster, although I only could try it with a

Re: [sqlite] Potential problem in SQLite 3.7.16.2

On Tue, Apr 30, 2013 at 3:34 AM, Mario M. Westphal wrote: > Hi, > > I just tried this (sorry dor the delay) but apparently I'm not having the > right toolset installed. > Please download the latest amalgamations from http://www.sqlite.org/draft/download.html -- D. Richard

Re: [sqlite] Potential problem in SQLite 3.7.16.2

Hi, I just tried this (sorry dor the delay) but apparently I'm not having the right toolset installed. The make file requires gawk.exe (which I downloaded from sourceforge), but now it's complaing about a missing tclsh85... Since the previous SQLite version works fine I think I'll skip this and

Re: [sqlite] Potential problem in SQLite 3.7.16.2

On Mon, Apr 22, 2013 at 8:20 AM, Mario M. Westphal wrote: > > So far I only used the Amalgamation. Looks like the files on your source > control server require me to build SQLite from source or at least run a > tool/script to build the amalgamation. > > I'm using Windows and

Re: [sqlite] Potential problem in SQLite 3.7.16.2

So far I only used the Amalgamation. Looks like the files on your source control server require me to build SQLite from source or at least run a tool/script to build the amalgamation. I'm using Windows and Visual Studio so the standard Linux build tools and scripting languages are not available.

Re: [sqlite] Potential problem in SQLite 3.7.16.2

On Thu, Apr 18, 2013 at 3:27 AM, Mario M. Westphal wrote: > > After downloading and compiling in the SQLite 3.7.16.2, we have a problem. > > The INSERT statement which takes only a few seconds with previous builds > now does not return, at least not within several minutes. > It's

Re: [sqlite] Potential problem in SQLite 3.7.16.2

FWIW: The following script demonstrates the problem: CREATE TABLE t1(x INTEGER, y INTEGER); CREATE INDEX t1xy ON t1(x,y); CREATE INDEX t1y ON t1(y); CREATE TABLE t2(x INTEGER PRIMARY KEY, y INTEGER); CREATE TABLE t3(x INTEGER PRIMARY KEY, y INTEGER); CREATE INDEX t3y ON t3(y); .wheretrace off

Re: [sqlite] Potential problem in SQLite 3.7.16.2

On Fri, Apr 19, 2013 at 9:17 AM, Mario M. Westphal wrote: > Hi, thanks. > > But I'm not sure that I understand you correctly. > > Is this behavior considered as something that needs to be looked at by the > SQLite Team to restore the original performance, or is this how "it is"

Re: [sqlite] Potential problem in SQLite 3.7.16.2

Hi, thanks. But I'm not sure that I understand you correctly. Is this behavior considered as something that needs to be looked at by the SQLite Team to restore the original performance, or is this how "it is" now and I have to find a work-around for good (e.g. applying your suggestion with

Re: [sqlite] Potential problem in SQLite 3.7.16.2

On Thu, Apr 18, 2013 at 3:27 AM, Mario M. Westphal wrote: > We can provide a sample database etc. on request. > Can you send the database to my private email, please? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list

Re: [sqlite] Potential problem in SQLite 3.7.16.2

The change in behavior occurs with http://www.sqlite.org/src/info/38852f158a If you need a work-around, change INNER to CROSS in the queries and the old query plan will be restored. On Thu, Apr 18, 2013 at 3:27 AM, Mario M. Westphal wrote: > This is a SQL Script > > > /* >

Re: [sqlite] Potential problem in SQLite 3.7.16.2

Hi, Celemens I created the requested log data by running the same operations in my application, once compiled with the 3.7.15.1 version (OK) and once with the 3.7.16.2 (BAD performance). The query plans are quite different. 1. --- The query my application runs for this test INSERT INTO

Re: [sqlite] Potential problem in SQLite 3.7.16.2

Mario M. Westphal wrote: > The INSERT statement which takes only a few seconds with previous builds > now does not return, at least not within several minutes. Please show the output of EXPLAIN QUERY PLAN for the SELECT part of the query in both versions. Regards, Clemens