Ruslan Zasukhin wrote:
> on 30/3/01 19:13, Oreste Tommasi at tommasi /AT/ infmedia .DOT sns.it wrote:
>
> > Most of our binary items are very short (10-20 B), so even a 128 B segment
> > would be to long. Is there the possibility of having BSOB (Binary Small
> > OBjects) or a VarBinary with an occupation similar to VarChars? Otherwise we
> > have to implement a structured grouping/ungrouping procedure among related
> > items (they can be logically grouped, with an average group size of 30
> > items).
>
> If you have so different by size items then it is good to use 2-3 different
> fields with different segment size.
>
> For 10-20 bytes items of course ideal is VarChar field.
> but problem that you using V4MD ...
> >From other products you'd could do that.
>
> I am going to add VarBinary, but not so fast.
>
> what is your time line?
> I hope to hear in answer 1-3 months :-)
We must deliver the product in 4 months, but in a few (3-4) days we must take our
decision about database engine.
If you can provide a way of recording binary data in BLOBs from VMD4, we could do
the following:
- use two fields to store the binary items (as you suggested), one is VarChar, one
is BLOB.
- when the items are small, we save them in the VarChar fields with a special
conversion (i.e. uuencode) to avoid string truncation;
- when the items are big, we save them directly in the BLOB field.
In the last case it would be important to avoid uuencoding because of the data size.
In conclusion, if you are so kind to add the WriteBLOBData function to VMD4, I think
we have a solution good enough to start; if we'll have VarBinary, then we'll throw
away the uuencoding/deconding procedures, and we'll have more compact files and
faster execution.
Please tell us when you believe to have the VMD4 modified.
Thanks for your FANTASTIC support.
Bye,
--
Oreste Tommasi,
Managing Director
mailto:tommasi@infmedia.it
mobile +39 0348 3044439
==========================================
I N F M E D I A http://www.infmedia.it
- Multimedia for Science and Education -
------------------------------------------
Sede operativa: Via Turati n.35
56125 PISA (Italy)
Tel +39 050 2207368
Fax +39 050 40449
==========================================
©2001 Oreste Tommasi |
