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
t;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 undocumente
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...@mailinglists.sqlite.org] On Behalf Of David Raymond
>Sen
-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 current tip of
and 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 tip
inal 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 improve
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 p1p2p3p4 p5
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 with "explain comment
>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.
>
>
>sqlite
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
Just showing with "explain comments" enabled.
sqlite> explain update foo set x = 1 where rowid = 1;
addr opcode p1p2p3p4 p5 comment
- - -- -
0 Init 0 33000
12 matches
Mail list logo