1. Jonathan Ashwell
  2. Valentina Database ADK
  3. 土, 5月 08 2021, 02:13 PM
  4.  メールで購読
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?
コメント
There are no comments made yet.
Ruslan Zasukhin 承諾済みの回答
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.
コメント
There are no comments made yet.
Jonathan Ashwell 承諾済みの回答
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.
コメント
There are no comments made yet.
Ruslan Zasukhin 承諾済みの回答
Hi John,

But this is a strict limit.
what if you will get data 4090 bytes or even 5000?
コメント
There are no comments made yet.
Jonathan Ashwell 承諾済みの回答
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.
コメント
There are no comments made yet.
  • ページ :
  • 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