on 30/3/01 17:39, Oreste Tommasi at tommasi .AT. infmedia D.O.T sns.it wrote:
>> I think I can simplify your life :-)
>> your task can be easy resolved IF
>>
>> I little improve V4MD extending its ability to work with MemBuffer and BLOB.
>> In particular I will add functions like:
>>
>> BLOB.WriteBLOBData( gCursor, pMemBuffer )
>>
>> where pMemBuffer is long number -- pointer to RAM buffer.
>>
>> Now you can easy develop YOUR OWN Xtra which will build this RAM buffer and
>> returns its pointer as long value. You see ?
>>
>> I have implement this way already in VXCMD.
>> Was going add it to V4MD.
>>
>> What you think ?
>
> Wonderful! This could solve our problem.
Okay, so this task get higher priority.
> Another question about space on disk: our single binary item can be variable
> in size from 4 B to hundreds of kB; statistically, we have many short binary
> items and few big items. For us the size of database files is important: if we
> use a BLOB field with short binary items, which will be the occupation on
> disk? It si comparable with that of a VarChar field (+4 B for the BLOB
> pointer), or it is strongly affected by the BLOB segment size?
If MOST of values are close to 4-5-6KB and only sometimes you get big item,
then best choice is about 6-6.5 KB
In this case if you have item 60KB then it will use say 10 segments and you
get overhead 32 * 10 = 320 bytes.
320 bytes / 60 KB = 0.5%
--
Best regards,
Ruslan Zasukhin
-------------------------
Paradigma.
e-mail: ruslan@paradigmasoft.com
web : http://www.paradigmasoft.com
To subscribe to the Valentina mail list
send a letter to valentina-on .AT. lists D.O.T macserve.net
©2001 Ruslan Zasukhin |
