om: drhsql...@gmail.com On Behalf Of Richard Hipp
Sent: Saturday, September 15, 2018 2:46 PM
To: SQLite mailing list
Cc: de...@outlook.com
Subject: Re: [sqlite] SQLITE touches unchanged expression indexes on update
On 9/11/18, Deon Brewis wrote:
> It seems like there is an opportunity fo
On 9/11/18, Deon Brewis wrote:
> It seems like there is an opportunity for improvement on updates if an index
> contains expressions.
This enhancement did not make the cutoff for 3.25.0. But as 3.25.0 is
now out, I have started the next release cycle and you can find this
enhancement on the late
--
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of David Raymond
>Sent: Wednesday, 12 September, 2018 12:12
>To: SQLite mailing list
>Subject: Re: [sqlite] SQLITE touches unchanged expression indexes on
>update
>
>Whoa, all sorts of undocu
sure that the
>Windows readahead is always disabled even when the OS is not WINCE.
---
The fact that there's a Highway to Hell but only a Stairway to Heaven says a
lot about anticipated traffic volume.
>-Original Message-
>From: sqlite-users [mailto:sqlite-users-
>boun...
600
sqlite>
-Original Message-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of Keith Medcalf
Sent: Wednesday, September 12, 2018 1:04 PM
To: SQLite mailing list
Subject: Re: [sqlite] SQLITE touches unchanged expression indexes on update
The version is the
d the repro with Partial Indexes as well.
- Deon
-Original Message-
From: sqlite-users On Behalf Of
Keith Medcalf
Sent: Wednesday, September 12, 2018 10:04 AM
To: SQLite mailing list
Subject: Re: [sqlite] SQLITE touches unchanged expression indexes on update
The version is the current t
-Original Message-
From: sqlite-users On Behalf Of
Richard Hipp
Sent: Wednesday, September 12, 2018 7:05 AM
To: SQLite mailing list
Subject: Re: [sqlite] SQLITE touches unchanged expression indexes on update
On 9/11/18, Deon Brewis wrote:
> It seems like there is an opportunity for improvem
Behalf Of Keith Medcalf
>Sent: Wednesday, September 12, 2018 11:40 AM
>To: SQLite mailing list
>Subject: Re: [sqlite] SQLITE touches unchanged expression indexes on
>update
>
>
>Interesting ... I get different output with explain comments enabled:
>
>addr opcode
l Message-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of David Raymond
>Sent: Wednesday, 12 September, 2018 07:54
>To: SQLite mailing list
>Subject: Re: [sqlite] SQLITE touches unchanged expression indexes on
>update
>
>Just showing w
sers-
>boun...@mailinglists.sqlite.org] On Behalf Of David Raymond
>Sent: Wednesday, 12 September, 2018 07:54
>To: SQLite mailing list
>Subject: Re: [sqlite] SQLITE touches unchanged expression indexes on
>update
>
>Just showing with "explain comments" enabled.
>
>
>s
On 9/11/18, Deon Brewis wrote:
> It seems like there is an opportunity for improvement on updates if an index
> contains expressions.
Thanks for bringing this to our attention.
We're on lockdown for the 3.25.0 release (bug fixes only) but I did
start looking at this to see how feasible it would
18 8:20 PM
To: SQLite mailing list
Subject: [sqlite] SQLITE touches unchanged expression indexes on update
It seems like there is an opportunity for improvement on updates if an index
contains expressions.
In the following example:
CREATE TABLE Foo(x, y, z);
CREATE INDEX FooX on Foo(x);
CREATE INDE
It seems like there is an opportunity for improvement on updates if an index
contains expressions.
In the following example:
CREATE TABLE Foo(x, y, z);
CREATE INDEX FooX on Foo(x);
CREATE INDEX FooZ on Foo(z);
CREATE INDEX FooLenZ on Foo(length(z));
explain UPDATE foo SET x=1 WHERE rowid=1;
I
13 matches
Mail list logo