1. Jonathan Ashwell
  2. Valentina Database ADK
  3. Суббота, Май 08 2021, 02:13 PM
  4.  Подписаться через 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?
Комментарий
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.