Re: [sqlite] To index or not to index?

On Mon, Jun 13, 2011 at 8:46 AM, Richard Hipp wrote: > That depends on what fraction of entries have isOnline=1.  If isOnline is > rare, then an index might be helpful.  But if roughly have the entires have I wondered about that. > It seems to me, though, that you are committing the classic erro

Re: [sqlite] To index or not to index?

On Mon, Jun 13, 2011 at 7:51 AM, Ian Hardingham wrote: > Hey guys, once again sorry for spamming at the moment. > > This is a simple question. > > My user account table has a field "isOnline INT".  This table has, say, > 100,000 rows. My understanding is that if the number of possible values in a