That also brings up the simple solution in that if you know you're db is going to be in the 200GiB range, declare a larger page size before creating the DB.
Sam ------------------------------------------- We're Hiring! Seeking a passionate developer to join our team building Flex based products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, December 13, 2007 12:21 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] SQLite and Columnar Databases Joe Wilson <[EMAIL PROTECTED]> wrote: ... The size of the bitmap is 256 bytes per megabyte of database file assuming a 1KiB page size. That translates into about 52MB for a 200GiB database. ... -- D. Richard Hipp <[EMAIL PROTECTED]> ---------------------------------------------------------------------------- - To unsubscribe, send email to [EMAIL PROTECTED] ---------------------------------------------------------------------------- - ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------