DB size

[Ruslan Zasukhin]

On 12/9/04 9:23 PM, "jda" <jda at his.com> wrote:

Hi Jon,

> Maybe it's too soon to start optimizing (but perhaps not), but I
> wonder about what is going to happen with db sizes. One of my beta
> testers reports that a db that was 26 MB in V1.x is now 55 MB in V2
> (11,000 records).

Actually this is quite reasonable.
Database is in UTF16 format now, so each string use 2 time more.


> I have users with well over 50,000 records, which
> if this is linear will be > 250 MB!

And now it is 125MB, right ?

> I've found that a db with one
> (empty) records has gone from about 260K (V1.11) to 1.7 MB (v2). Are
> we going to be able to get back to the V1.x db sizes?

Empty database is a question. But if remember that empty database also have
system tables with about 200 records, and indexes on them, then may be also
looks reasonable.

Solution will be only in use of UTF8.
It must be the same size -- 1 byte per char.

In the same time SYSTEM TABLES always will be in UTF16


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------