> In the case of SQLite, it is also very unlikely to save space. In > fact, because of the way integer values are stored, it is very > likely to use more space. >
Jay, In most cases yes, but there are ones with several integers that should be used together in ordering, the space is wasted since sqlite saves the table b-tree with the rowid + these integers and also index b-tree with the integers and rowid reference. When such tables contains thousands or millions records, it starts making sense. Using rowid in this case as a packed value should help. Ironically sqlite being db right before you with all the statistics available encourages experimenting opposite to for example mysql looking like a mountain far away ) Max _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
