On 7/6/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
I'm guessing that the random I/O behavior of SQLite will frustrate the compression implemented by NTFS and Reiser. The end result will be a database file that might actually take up more space than if it were uncompressed. I'd be interested in hearing about experiments to prove or disprove this conjecture.
Sounds like it would take a bit of work to ensure you're measuring the right thing. I'm not sure how you'd turn off the caching of the database in RAM.