Josh Marell <macman...@gmail.com> wrote: > I would say that couple should be a 3 column table, with coupleID, > partner1ID, partner2ID. It looks like right now, you have just coupleID and > partnerID, that doubles the number of rows you have.
On the other hand, this would make many queries more complicated. Try generating a list of all grandparents in this model. Also, those ORs you will have to use tend to prevent SQLite from using indexes. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
