On Wed, Feb 02, 2011 at 03:38:07PM -0800, Jim Morris wrote: > I'd probably move the analyze out of the loop. > > Since your joining on props.id a better index pind might be > create index pind on props (id, pnam)
Yes, you probably want two covering or partially-covering indexes: CREATE INDEX pind ON props (id, pnam, pval); CREATE INDEX pind ON props (pval, pname, id); The first is for when you need to join on 'id' and want to extract attribute/values. The second is for when you want to search by attribute/values and need to get rowids back. Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
