Re: [sqlite] Just want to double check on index need

On Oct 14, 2010, at 11:56 PM, Alan Chandler wrote: > On 14/10/10 17:28, Dan Kennedy wrote: >> >> On Oct 14, 2010, at 10:43 PM, Alan Chandler wrote: >>> CREATE TABLE div_winner_pick ( > ... >>> PRIMARY KEY (cid,confid,divid,uid) >>> ); > > ... >>> >>> CREATE INDEX div_win_pick_uid_cid_idx ON

Re: [sqlite] Just want to double check on index need

On 14/10/10 17:28, Dan Kennedy wrote: > > On Oct 14, 2010, at 10:43 PM, Alan Chandler wrote: >> CREATE TABLE div_winner_pick ( ... >> PRIMARY KEY (cid,confid,divid,uid) >> ); ... >> >> CREATE INDEX div_win_pick_uid_cid_idx ON div_winner_pick (uid,cid); ... > It should be clearer.

Re: [sqlite] Just want to double check on index need

On Oct 14, 2010, at 10:43 PM, Alan Chandler wrote: > I am porting an application (American Football Results Picking > Competition) over from a Postgres databaseo to SQLite which involves > some fairly intense queries. I am doing this partially to do some > performance comparisons although I

[sqlite] Just want to double check on index need

I am porting an application (American Football Results Picking Competition) over from a Postgres databaseo to SQLite which involves some fairly intense queries. I am doing this partially to do some performance comparisons although I have some other reasons too. I just want to make sure that I