1. Jonathan Ashwell
  2. Valentina Database ADK
  3. Saturday, May 08 2021, 02:13 PM
  4.  Subscribe via email
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?
Comment
There are no comments made yet.
Ruslan Zasukhin Accepted Answer
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.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 1
Jonathan Ashwell Accepted Answer
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.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 2
Ruslan Zasukhin Accepted Answer
Hi John,

But this is a strict limit.
what if you will get data 4090 bytes or even 5000?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 3
Jonathan Ashwell Accepted Answer
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.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 4
  • Page :
  • 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