Re: [sqlite] Curious SQLite performance observation

...@sqlite.org] on behalf of Hauptmann Peter [hauptma...@yahoo.com] Sent: Thursday, January 05, 2012 10:06 AM To: sqlite-users@sqlite.org Subject: EXT :[sqlite] Curious SQLite performance observation This isn't a question as much as an observation that might be interesting for others, too, though

[sqlite] Curious SQLite performance observation

This isn't a question as much as an observation that might be interesting for others, too, though I'd share. Having a table building a tree by each item referencing its parent:       // Table Items       CREATE TABLE [Items] (         [iRowID] INTEGER PRIMARY KEY,          [iParentRowID]