[sqlite] Using a "personal" partial index

2016-03-28 Thread Simon Slavin
On 28 Mar 2016, at 1:27am, David Rayna wrote: > I got excited when I saw the "indexed by" clause. > A technique I used years ago with FoxPro & etc was to allow each user to > create his own personal index of the same data. > FoxPro allowed storing index files separately and on each user's own

[sqlite] Using a "personal" partial index

2016-03-27 Thread Richard Hipp
On 3/27/16, David Rayna wrote: > I got excited when I saw the "indexed by" clause. > A technique I used years ago with FoxPro & etc was to allow each user to > create his own personal index of the same data. That's not what INDEX BY does. An you cannot really give each user their own private

[sqlite] Using a "personal" partial index

2016-03-27 Thread David Rayna
I got excited when I saw the "indexed by" clause. A technique I used years ago with FoxPro & etc was to allow each user to create his own personal index of the same data. FoxPro allowed storing index files separately and on each user's own local C: drive. The index was on a complex computed