Hi, first i´d like to thank the people on this list that I have found to be very helpful in the past. This list is truly great and friendly.
I got two questions today: I have two tables, a standard one and an rtree table, which are both linked together logically by the ID field of the rtree table. 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? And regarding Indices: my standard table has two indices, one for the coloumn ID (since it is being referenced from the rtree), plus another one on a coloumn which I use for sorting the results coming from that table. Are indices also used for sorting results, or do they do just apply for searching? Thanks in advance, 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
