NEW: Vstring field now will eat 1-2 bytes less per record!

Ruslan Zasukhin sunshine at public.kherson.ua
Wed Sep 1 16:52:20 CDT 2004


Hi All,

I have found that in Valentina 1.x I have spend one byte for Vstring field.
End zero byte

If user says Vstring( 10 )
Then on disk each record have use 11 bytes.

Now 2.0 will use 10 bytes exactly.


It can be huge win fir huge db.
E.g. If you have table in 10 millions of records then we win

    10MB for UTF8
    20MB for Unicode

In case table have just one Vstring field.

If it have e..g 5 fields then we win

    5 * 10MB = 50M for UTF8
    5 * 20MB = 100MB for Unicode


Also, Vstring(1) now will eat exactly one byte on disk.


-- 
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
-------------------------------------------------------------



More information about the Valentina-beta mailing list