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