Re: [sqlite] About the performance of recursive WITH

2017-02-17 Thread Jean-Luc Hainaut
b < GRAPH-performance-iterative.sql TimeThis :Start Time : Thu Feb 16 07:22:28 2017 TimeThis : End Time : Thu Feb 16 07:22:28 2017 TimeThis : Elapsed Time : 00:00:00.124 -----Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Je

Re: [sqlite] About the performance of recursive WITH

2017-02-17 Thread Jean-Luc Hainaut
.00 sys 0.00 TimeThis : Command Line : sqlite64 graph.db < GRAPH-performance-iterative.sql TimeThis :Start Time : Thu Feb 16 07:22:28 2017 TimeThis : End Time : Thu Feb 16 07:22:28 2017 TimeThis : Elapsed Time : 00:00:00.124 -Original Message----- From: sqlite-user

Re: [sqlite] About the performance of recursive WITH

2017-02-16 Thread Keith Medcalf
8 2017 TimeThis : Elapsed Time : 00:00:00.124 > -Original Message----- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of Jean-Luc Hainaut > Sent: Thursday, 16 February, 2017 05:57 > To: SQLite mailing list > Subject: [sqlite] About the perf

[sqlite] About the performance of recursive WITH

2017-02-16 Thread Jean-Luc Hainaut
Hi, This post concerns a strange (imho) behaviour of recursive WITH update query as far as execution time is concerned. I have created (in an "In memory" DB) a table that stores a set of nodes arranged in a tree structure (actually the skeleton of the contents of a Windows folder): crea