On Tue, Jun 2, 2009 at 10:45 PM, Jan <janus...@gmx.net> wrote: > Sounds good. I think I try that. Although updating is usually not > necessary (once you have a mother/father its usually difficult to get > rid of/update them .-) I read that there is problem with queries that go > deeper in grand-grand-.. parents structure. But I think I can do a loop > in my code.
If you don't want to update, but you do want to query for entire subtrees, do give nested sets more consideration. The best encoding for intervals I've yet seen is here: http://arxiv.org/pdf/0806.3115v1 Best wishes, Hamish _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
