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
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
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) +
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.
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
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
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.
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
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
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
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
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
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
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.
>
>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
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
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
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
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
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
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:
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
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
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:
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
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:
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
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
28 matches
Mail list logo