Christophe Leske wrote: >>> Can I spare some bytes in my DB by defining the ID field of the >>> standard >>> table as being a foreign key of the rtree table? In other words, when >>> defining a foreign key, is the coloumn referencing the ID field of the >>> foreign table and thus NOT replicating them (using a smaller memory >>> footprint in the file)? >>> Or does the table which has a foreign key still have its own ID >>> coloumn? >>> >> The ID column is replicated in each table. >> > Is there a construct in sqlite which would allow a coulumn to be shared > amongst tables in such a way that the data is there only once, thus creating > a smaller file? > > In the example provided, the iDs are exactly the same, yet they are there > twice... > "Third Normal Form" data design. > > > Christophe Leske > > www.multimedial.de - [EMAIL PROTECTED] > http://www.linkedin.com/in/multimedial > Lessingstr. 5 - 40227 Duesseldorf - Germany > 0211 261 32 12 - 0177 249 70 31 > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users