Yes, things are very tight on all of our products over here as well!

I would like to know what causes a bloated file.

Thanks,
Allan

http://www.aspire.ws
http://store.aspire.ws 

-----Original Message-----
From: Roy Black [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, April 07, 2004 10:38 PM
To: [EMAIL PROTECTED]
Subject: Fw: [sqlite] A proposal for SQLite version 3.0

I have no clue how Jakub Adamek gets 3x bigger files than MS Access. I
always get 2x less.

----- Original Message -----
From: "D. Richard Hipp" <[EMAIL PROTECTED]>
To: "Jakub Adamek" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, April 07, 2004 9:10 AM
Subject: Re: [sqlite] A proposal for SQLite version 3.0


Jakub Adamek wrote:
 > My experience is that SQLite makes roughly about 3x bigger files than MS
> Access. How would this change in 3.0?
 >

SQLite is very storage efficient in the common case.  In a typical table,
SQLite will use about 4 or 5 bytes of disk space for every 3 bytes of actual
data stored.  Put another way, about 60% to 75% of an SQLite database file
is the actual data being stored and the other 40% to 25% is overhead.

If you have an example where the overhead is significantly larger than this,
I'd be interested in seeing it.

The new version 3.0 file format is anticipated to reduce overhead by about
5%.  YMMV, of course.

--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565


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






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


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

Reply via email to