On Fri, Jul 18, 2008 at 11:58:16AM -0700, Corey Nelson scratched on the wall: > > sqlite3 Ticks.db ".dump" > BEGIN TRANSACTION; > CREATE TABLE StockName (date TEXT UNIQUE ON CONFLICT REPLACE, price REAL);
> I would expect the database file to store a bit of "extra" data but it's > 2.17 times bigger than the text file! As others have pointed out, the issue is with the index, which is created automatically by the "UNIQUE" constraint. In SQLite an index holds a full copy of the data. Since the vast majority of your data (byte wise) is the date string, slightly more than 2x sounds just about right. You can try to convert the date to a large integer. SQLite supports up to 64 bit ints (signed), which should hold your current representation without problems. You'll still have two copies, but the data should be much smaller. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "'People who live in bamboo houses should not throw pandas.' Jesus said that." - "The Ninja", www.AskANinja.com, "Special Delivery 10: Pop!Tech 2006" _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
