Re: [sqlite] Potential problem in SQLite 3.7.16.2

2013-04-30 Thread Mario M. Westphal
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

2013-04-30 Thread Richard Hipp
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

[sqlite] Performance HELP

2013-04-30 Thread peter korinis
This question regards SQLite (3.6) performance. (Lengthy because I want to describe the environment.) . Win-7 (64-bit, though I don't know if SQLite uses 64-bit). . 3 year old HP laptop with Intel Core Duo CPU P8400 @ 2.27GHz with only 4GB memory . 286GB HD (50% full) +

[sqlite] Support SQLite in México

2013-04-30 Thread Francisco Puente Moreno
Hello, I'm working for a Mexican company and we are thinking use SQLite for some develops, but we need to know if there is any company in México that give direct support to SQLite if we have a contingency. Thanks in advance! Regards! Francisco Puente, Eng.

[sqlite] Segmentation fault in SQLite parser

2013-04-30 Thread Eelco Dolstra
Hi, I ran into the following regression after upgrading from SQLite 3.7.14.1 to 3.7.16.2: the SQLite parser crashes when it encounters a subquery enclosed in double parentheses. For example: $ sqlite3 SQLite version 3.7.16.2 2013-04-12 11:52:43 Enter ".help" for instructions Enter SQL

Re: [sqlite] Performance HELP

2013-04-30 Thread Simon Slavin
On 29 Apr 2013, at 4:08pm, peter korinis wrote: Thanks for your detailed description of your use of SQLite which saved a lot of questions. > 1. Is my current DB too large for SQLite to handle efficiently? I just > read in O'Reilly, Using SQLite, book, "If you need

Re: [sqlite] Support SQLite in México

2013-04-30 Thread Simon Slavin
On 29 Apr 2013, at 4:46pm, Francisco Puente Moreno wrote: > Hello, I'm working for a Mexican company and we are thinking use SQLite for > some develops, but we need to know if there is any company in México that > give direct support to SQLite if we have a contingency.

Re: [sqlite] Support SQLite in México

2013-04-30 Thread Stephen Chrzanowski
SQLite is something you add into an application that you're building. It isn't something like MySQL, MSSQL, Oracle, or anything like a client/server architecture. It is a library that your code links to either via DLL or other type of library. Consider it for light use web services, desktop

Re: [sqlite] Performance HELP

2013-04-30 Thread Eduardo Morras
On Mon, 29 Apr 2013 11:08:48 -0400 "peter korinis" wrote: > This question regards SQLite (3.6) performance. (Lengthy because I want to > describe the environment.) > > . Win-7 (64-bit, though I don't know if SQLite uses 64-bit). > > . 3 year old HP

Re: [sqlite] Support SQLite in México

2013-04-30 Thread ajm
Hi Francisco: I can tell you that this list, is plenty of very clever people who sure can help you if in trouble -supposing you know how to ask-. Usually here a an incredible technical level and service intention for free. But as a last resource, you can get professional support from the

[sqlite] LIKE and GLOB questions

2013-04-30 Thread Staffan Tylen
I have the following two questions to share: First, assume two tables t1 and t2 where t1 has a text column a with data and t2 has a text column p with patterns in LIKE format. For each a in t1 I want to find all matching patterns p in t2. Is this possible using a single SELECT clause? I've been

Re: [sqlite] LIKE and GLOB questions

2013-04-30 Thread Clemens Ladisch
Staffan Tylen wrote: > First, assume two tables t1 and t2 where t1 has a text column a with data > and t2 has a text column p with patterns in LIKE format. For each a in t1 I > want to find all matching patterns p in t2. Is this possible using a single > SELECT clause? SELECT * FROM t1 JOIN t2 ON

Re: [sqlite] LIKE and GLOB questions

2013-04-30 Thread Richard Hipp
On Tue, Apr 30, 2013 at 12:52 PM, Staffan Tylen wrote: > I have the following two questions to share: > > First, assume two tables t1 and t2 where t1 has a text column a with data > and t2 has a text column p with patterns in LIKE format. For each a in t1 I > want to find

Re: [sqlite] Query optimizer bug?

2013-04-30 Thread Richard Hipp
On Thu, Mar 14, 2013 at 2:07 PM, Ryan Johnson wrote: > Hi all, > > I'm running sqlite-3.7.13 on cygwin. Playing around with various TPC-H > queries with my class recently, I hit a strangely slow query and don't > understand why it's so slow. >

Re: [sqlite] Support SQLite in México

2013-04-30 Thread Jeff Archer
>Francisco Puente Moreno fpm.mty74 at hotmail.com >Mon Apr 29 11:46:05 EDT 2013 > >Hello, I'm working for a Mexican company and we are thinking use SQLite for some develops, but >we need to know if there is any company in México that give direct support to SQLite if we have a >contingency. >Thanks

Re: [sqlite] Query optimizer bug?

2013-04-30 Thread Ryan Johnson
On 30/04/2013 12:59 PM, Richard Hipp wrote: On Thu, Mar 14, 2013 at 2:07 PM, Ryan Johnson wrote: Hi all, I'm running sqlite-3.7.13 on cygwin. Playing around with various TPC-H queries with my class recently, I hit a strangely slow query and don't understand why

Re: [sqlite] Query optimizer bug?

2013-04-30 Thread Richard Hipp
On Tue, Apr 30, 2013 at 4:35 PM, Ryan Johnson wrote: > On 30/04/2013 12:59 PM, Richard Hipp wrote: > >> On Thu, Mar 14, 2013 at 2:07 PM, Ryan Johnson >> **wrote: >> >> Hi all, >>> >>> I'm running sqlite-3.7.13 on cygwin. Playing around

Re: [sqlite] Query optimizer bug?

2013-04-30 Thread Nico Williams
On Tue, Apr 30, 2013 at 11:59 AM, Richard Hipp wrote: > http://www.sqlite.org/draft/queryplanner-ng.html That's quite interesting. Should the user have a way to influence the query planner? Perhaps by indicating a cost for each table source? SQL is supposed to let the RDBMS

Re: [sqlite] Query optimizer bug?

2013-04-30 Thread Ryan Johnson
On 30/04/2013 5:20 PM, Nico Williams wrote: On Tue, Apr 30, 2013 at 11:59 AM, Richard Hipp wrote: http://www.sqlite.org/draft/queryplanner-ng.html That's quite interesting. Should the user have a way to influence the query planner? Perhaps by indicating a cost for each

Re: [sqlite] Query optimizer bug?

2013-04-30 Thread Igor Tandetnik
On 4/30/2013 5:26 PM, Ryan Johnson wrote: Being able to force certain access methods (use *this* index, not that one) would be helpful, though (does "+" do that or just suggest it?). Unary plus turns a simple column reference (for which an index can be used) into an expression (which cannot

Re: [sqlite] Query optimizer bug?

2013-04-30 Thread Marc L. Allen
In looking at the draft plan... am I right in assuming that at any 'stop' you can eliminate paths which have consumed the identical set of nodes but are more expensive? For instance, at stop 2, the draft shows: R-N1 (cost: 7.03) N1-R (cost: 7.31) R-N2 (cost: 9.08) N2-R (cost:

Re: [sqlite] Query optimizer bug?

2013-04-30 Thread Richard Hipp
On Tue, Apr 30, 2013 at 5:46 PM, Marc L. Allen wrote: > In looking at the draft plan... am I right in assuming that at any 'stop' > you can eliminate paths which have consumed the identical set of nodes but > are more expensive? > Yes. Good idea. I have updated the

Re: [sqlite] Query optimizer bug?

2013-04-30 Thread Marc L. Allen
Another thought... since you are limiting yourself to a maximum number of paths at any given time, if you're willing to take the full hit for maintaining the full N=30 (or whatever) paths, instead of simply eliminating worse paths with identical nodes, allow yourself to continue finding more

Re: [sqlite] Query optimizer bug?

2013-04-30 Thread Marc L. Allen
Oops.. nevermind. You already had that covered. ;) That'll teach me to answer on my phone before reading the revised draft. From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] On Behalf Of Richard Hipp [d...@sqlite.org] Sent:

Re: [sqlite] Query optimizer bug?

2013-04-30 Thread Richard Hipp
On Tue, Apr 30, 2013 at 6:20 PM, Richard Hipp wrote: > > > On Tue, Apr 30, 2013 at 5:46 PM, Marc L. Allen < > mlal...@outsitenetworks.com> wrote: > >> In looking at the draft plan... am I right in assuming that at any 'stop' >> you can eliminate paths which have consumed the

[sqlite] Incorrect documentation for PRAGMA table_info (pk column)

2013-04-30 Thread Joey Adams
The documentation for PRAGMA table_info says: The 'pk' column in the result set is zero for columns that are not part of the primary key, and is the index of the column in the primary key for columns that are part of the primary key." But in reality, pk = 1 for all the primary key columns:

Re: [sqlite] Incorrect documentation for PRAGMA table_info (pk column)

2013-04-30 Thread Richard Hipp
On Tue, Apr 30, 2013 at 10:13 PM, Joey Adams wrote: > The documentation for PRAGMA table_info says: The 'pk' column in the result > set is zero for columns that are not part of the primary key, and is the > index of the column in the primary key for columns that are

Re: [sqlite] Query optimizer bug?

2013-04-30 Thread James K. Lowden
On Tue, 30 Apr 2013 12:59:17 -0400 Richard Hipp wrote: > http://www.sqlite.org/draft/queryplanner-ng.html Feel free to use this version of the diagram. http://www.sqlite.org/draft/queryplanner-ng.html The directory contains the source file and PDF, too. Commands