Re: [sqlite] Foreign keys needing an index

2012-11-30 Thread Igor Tandetnik
Simon Slavin wrote: > Need someone more familiar with the design philosophy and source code than I > am (which is not at all). > > > > Says you need an index for anything which acts as a parent. I can understand > why

Re: [sqlite] Foreign keys needing an index

2012-11-30 Thread Jay A. Kreibich
On Fri, Nov 30, 2012 at 02:57:30PM +, Simon Slavin scratched on the wall: > Need someone more familiar with the design philosophy and source code than I > am (which is not at all). > > > > Says you need an index for anything which acts as

[sqlite] Foreign keys needing an index

2012-11-30 Thread Simon Slavin
Need someone more familiar with the design philosophy and source code than I am (which is not at all). Says you need an index for anything which acts as a parent. I can understand why under normal circumstances (large table) this would be