On Oct 26, 2008, at 5:58 PM, Julian Bui wrote: > HI everyone, > > I have records in my db that consist of smallint, bigint, smallint, > double, > char(8). By my calculation that comes to 2 + 8 + 2 + 8 + 8 = 28 > Bytes per > record. I also have an index over the attribute that is a double. > > I inserted 100,000 records into a clean database and the database > grew to > 240.0MB. That comes out to 2519 Bytes per record (240 * 1024 * 1024 / > 100,000). How is that possible? The index can't add THAT MUCH > extra space.
2519 bytes per row does seem excessive - by about two orders of magnitude. Have you tried running sqlite3_analyzer.exe on the database to see what is going on? How big is the database file after inserting only 100 records, instead of 100,000. Can you send me (via private email) a copy of the database with only 100 records so that I can poke around a bit? D. Richard Hipp [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
