Mikey C <[EMAIL PROTECTED]> wrote:
> Not sure what you mean there DRH, but I set compression on one of my database
> files on NTFS and file size shrunk from  1,289,216 bytes to 696,320 bytes.
> 
> And of course the whole compression / decompression process is completely
> transparent to SQLite and if you decide that compression is a bad thing, you
> just uncheck the box on that file and you are back to where you started.
> 

After turning compression on, try making lots of updates to
the database.  Does the database stay the same size?  Is
there a significant I/O performance hit?  I'm guessing that
the answer in both cases will be "yes".  Please let me know.
--
D. Richard Hipp   <[EMAIL PROTECTED]>

Reply via email to