>When you say the data changes, does the shape actually change? Because all that
>matters to analyze is the shape of the data, not the data itself.
Upon further analysis it appears that the data "shape" is different in
different periods within the table. That is, some sections have the inverse
s
I am resending this message below from 3 days ago because it never made it to
the list.
RP
PS: Messages seem to take a long time to go through the gmane system, at least
half a day and sometimes more in my experience so far.
On Tue, 11/11/14, RP
When using CTEs the rowid is null. The following returns "--NULL--"
.null --NULL--
with c(x) as (select 1)
select rowid from c;
RP
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listi
ecause I can't upload the entire 900MB database.
RP
----
On Sun, 11/9/14, RP McMurphy wrote:
Subject: Discrepancy with indexing and WHERE clause with AND/OR
To: sqlite-users@sqlite.org
Date: Sunday, November 9, 2014, 2:35 AM
If there is a large ta
If there is a large table and we need to select a subset of values using a
WHERE clause with an AND/OR construct sqlite has trouble finding the answer in
a reasonable time. Breaking the queries down into separate SELECT statements
speeds up the process exponentially.
For example the following t
>Perhaps this could be caught at compile time. The process that creates
>the amalgamation could add a preprocessor macro defining e.g.
>_SQLITE_AMALGAMATION_. The SQLITE_OMIT_* macros could test for that
>definition and #pragma error if found.
I think there is a much easier solution. Since th
Consider the following build cmd line:
gcc -o sqlite3.exe -DSQLITE_OMIT_WAL sqlite3.c shell.c
The build succeeds when using MinGW on Windows.
Now start the built exe with a memory database:
sqlite3 :memory:
And execute the following query:
create table v(y);
wi
7 matches
Mail list logo