I have a database that consists of about 13000 rows of about 20 fields. The fields are all integers, doubles, and timestamps. What's puzzling me is that the database is about 16M. I've looked at the file itself in a hex editor and I see that the 1k pages are all mostly empty. It looks like SQLite is only putting one row on a page even though there should be enough room for more rows. I've looked at other database files and they don't seem to have this problem.

I'm just curious if this is the expected behavior or not.

Thanks.


--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]



Reply via email to