1. Jonathan Ashwell
  2. Valentina Database ADK
  3. Samstag, Mai 08 2021, 02:13 PM
  4.  Abonnieren via E-Mail
I need to add a binary field to an existing database. It will typically hold 3-4 kB of data per record. I can't decide which to use, VBinary or VBlob. Which do you think would be more efficient, i.e. size?
Kommentar
There are no comments made yet.
Jonathan Ashwell Akzeptierte Antwort
I was just asking to be sure the docs were correct, because in your first reply you said the limit was 2044. Yes, I understand it's a hard limit. Thanks for clarifying that.
Kommentar
There are no comments made yet.
Ruslan Zasukhin Akzeptierte Antwort
Hi John,

But this is a strict limit.
what if you will get data 4090 bytes or even 5000?
Kommentar
There are no comments made yet.
Jonathan Ashwell Akzeptierte Antwort
Thanks, Ruslan, isn't VBinary good for 4088 bytes?

VBinary

Range of Type

This type of field can effectively store binary values (i.e. values that contain zero-bytes inside) of variable size with limit up to 4088 bytes per value.
Kommentar
There are no comments made yet.
Ruslan Zasukhin Akzeptierte Antwort
Hi Jon,

VarBinary is ok for values in range 20 - 2044

in your case, I think better VBLOB with segmentSize 2K or 4Kb,
depending of which values you think going to be more, small or bigger.
Kommentar
There are no comments made yet.
  • Seite :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories