Re: Fw: [sqlite] A proposal for SQLite version 3.0

[Mateusz Łoskot]

In 04/08/2004 05:38 AM, Roy Black wrote:
I have no clue how Jakub Adamek gets 3x bigger files than MS Access. I
always get 2x less.
How is it possible ?
My opinion is closer (but not exact) to Jakub's.
I have 3 databases, each database has the same structure (about 100
tables) but different amount of data.
Here you have my comparsion of disk spaces used by my databases
in MS Access and SQLiter format:
MS Access:
DB1 - 20MB
DB2 - 31MB
DB3 - 18MB
SQLite:
DB1 - 45MB
DB2 - 67MB
DB3 - 38MB
So, as you can see, after mdb2sqlite conversion, I get more than
2x bigger SQLite files.
Greets

--
Mateusz Łoskot, mateusz at loskot dot net
GNU/Linux (Slackware 9.1) http://counter.li.org #220771
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Fw: [sqlite] A proposal for SQLite version 3.0

[Roy Black]

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]