On Tue, 2005-07-12 at 18:28 +0200, Gotzon Astondoa wrote: > This is the number that i donĀ“t understand. Because: > (28.672 - 12.288)/510 = 31 bytes per row. > I think it will be: > 4 bytes for the group_id > 4 bytes for the domain > 4 bytes for the idx_domain > ------ > 12 bytes in total > > Where are the rest of the bytes (23 bytes)? >
The program sqlite3_analyzer available on the SQLite download page will give you a detailed account of out disk space is used for any database. Do not be confused by the name - someone else has written a completely different program by the same name. You want the "sqlite3_analyzer" that appears on on http://www.sqlite.org/download.html -- D. Richard Hipp <[EMAIL PROTECTED]>