I just noticed something rather stupid...
when you .dump a table via the sqlite.exe binary (2.8.15)... It dumps
first the "create table", then the "insert"s, and
afterwards the indexes
Now if you have a very big table it will take a LOT of time to place
those indexes... Maybe it is more perfo
Matt Wilson wrote:
>
> Works with the attached patch.
The patch is added. Tnx.
> Oh, forgot to mention that printf tests fail:
>
> They're all failures of this type:
> Expected: [Three integers: -1 17]
> Got: [Three integers: -1 377]
>
Can
On Wed, Sep 08, 2004 at 04:13:57PM -0400, D. Richard Hipp wrote:
>
> Please try the latest code in CVS and see if it helps. Tnx.
Works with the attached patch. Oh, forgot to mention that printf
tests fail:
Failures on these tests: printf-1.10.1 printf-1.10.2 printf-1.10.3 printf-1.10.4
printf-
Matt Wilson wrote:
On Wed, Sep 08, 2004 at 11:53:30AM -0400, Matt Wilson wrote:
That's not the solution. Your btree cursor (and other pointers) are
being truncated:
Please try the latest code in CVS and see if it helps. Tnx.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
Matt Wilson wrote:
On Wed, Sep 08, 2004 at 11:53:30AM -0400, Matt Wilson wrote:
That's not the solution. Your btree cursor (and other pointers) are
being truncated:
Here's a patch to correct this. There are also some cosmetic changes
to reduce warnings on 64 bit platforms. The patch may need to
On Wed, Sep 08, 2004 at 11:53:30AM -0400, Matt Wilson wrote:
>
> That's not the solution. Your btree cursor (and other pointers) are
> being truncated:
Here's a patch to correct this. There are also some cosmetic changes
to reduce warnings on 64 bit platforms. The patch may need to be
modified
Hi Richard,
I haven't had any response from anyone else so I thought I'd try you direct
Richard.
I'm wondering what logic I should employ to prevent mutual exclusion
occurring.
I'm using SQLite to record an audit trail from a web application - I count
the number of edits, searches and the maximu
Andrea Giammarchi wrote:
- Original Message -
From: "Simon Berthiaume"
Have you tried to change the order of the conditions in the WHERE
clause? I don't know the internal working of SQLite so they might
actualy give worst results. You can try something like that:
SELECT date_ext.mydate
- Original Message -
From: "Paolo Vernazza"
> I would try something like that
>
> SELECT
> date_ext.mydate as MyDate,
> city_ext.city as MyCity,
> number_ext.mynum as MyNumber
> FROM
> number_ext JOIN city_ext ON number_ext.city = city_ext.id JOIN
> date_ext ON num
On Wed, Sep 08, 2004 at 11:10:35AM -0400, D. Richard Hipp wrote:
>
> Please try again with the lastest version under CVS and see if it helps.
> Check-in [1948] will have fixed this problem if I am not badly mistaken.
That's not the solution. Your btree cursor (and other pointers) are
being trunc
I thought I posted this yesterday, but it seems to have gotten lost. Trying
again...
[EMAIL PROTECTED] writes:
> Using version 2.8.15, I'm doing the equivalent (via the API) of this:
>
> sqlite /tmp/db1
> PRAGMA SYNCHRONOUS=OFF;
> ATTACH '/tmp/db2' AS db2;
>
> db2 has previously
Al Danial wrote:
On my 64 bit Linux system (Opteron, Gentoo 2004.1 amd_64), the v3.0.6
code builds fine but seg faults during 'make test' in one of the blob tests.
Today I built the code with debugging enabled and used gdb to get a
traceback. It failed at line 411 of src/util.c, in a strlen() call
Andrea Giammarchi wrote:
However I've tried to leave mydate search and compare just city_ext and
number_ext these two table are very slow with a simple match of one id
.
Any new ideas ?
I would try something like that
SELECT
date_ext.mydate as MyDate,
city_ext.city as MyCity,
n
On Tue, 7 Sep 2004, Al Danial wrote:
>On my 64 bit Linux system (Opteron, Gentoo 2004.1 amd_64), the v3.0.6
>code builds fine but seg faults during 'make test' in one of the blob tests.
>Today I built the code with debugging enabled and used gdb to get a
>traceback. It failed at line 411 of src/u
Scott McCaskill wrote:
> I've been experimenting with using the sqlite3Btree* functions by themselves.
> I'd like to have sqlite3BtreeMoveto use the comparison function (instead of
> an int key), but I see from looking at the code that it never does this for
> pages marked as INTKEY. What causes p
Gerry,
That works! Thanks much. I guess everybody is busy trying to solve the big stuff.
rc
> -Original Message-
> From: Gerry Snyder [SMTP:[EMAIL PROTECTED]
> Sent: Tuesday, September 07, 2004 5:33 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [sqlite] Error: Can't find package sqlite
- Original Message -
From: "Simon Berthiaume"
> Have you tried to change the order of the conditions in the WHERE
> clause? I don't know the internal working of SQLite so they might
> actualy give worst results. You can try something like that:
>
> SELECT date_ext.mydate as MyDate, city_e
I've been experimenting with using the sqlite3Btree* functions by themselves. I'd
like to have sqlite3BtreeMoveto use the comparison function (instead of an int key),
but I see from looking at the code that it never does this for pages marked as INTKEY.
What causes pages to be marked this way?
On Mon, 06 Sep 2004 12:17:07 +0300, Rami Saarinen <[EMAIL PROTECTED]> wrote:
> Should I use triggers? But they seem limited as the only allow the
> execution of SQL statements.. so I could have a separate table where
> I'd collect the changed information and process the table after the
> UPDATE. Th
19 matches
Mail list logo