Skip to Content.
Sympa Menu

freetds - Re: [freetds] FreeTDS question about text size

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Igor Korot <ikorot01 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] FreeTDS question about text size
  • Date: Sat, 6 Oct 2018 00:50:25 -0500

Hi,

On Sat, Oct 6, 2018 at 12:35 PM Jacopille, David <DJacopille AT mfs.com> wrote:
>
> General question for a FreeTDS guru:
>
> We saw the warning in the freetds.conf file:
>
> # If you get out-of-memory errors, it may mean that your client
> # is trying to allocate a huge buffer for a TEXT field.
> # Try setting 'text size' to a more reasonable limit
> text size = 64512
>
> We needed more but we still tried to be reasonable:
>
> #text size = 64512
> client charset = UTF-8
> text size = 200000
>
> Of course we encountered a nvarchar(max) column that is holding way more
> than 200000 bytes and it seems to be getting truncated.

I would be curious why this field is not declared as BLOB?

Thank you.

>
> What is the impact of increasing text size to 10 MB?
>
> Are any of these three scenarios true?
>
> A. Every column, even an nvarchar(8), is allocated 10 MB
> B. The memory utilization is only what the column actually holds...up to
> 10 MB
> C. The memory utilization is determined by table design: an nvarchar(8)
> col would be allocated 16 bytes, and an nvarchar(max) would be allocated 10
> MB
>
> Thanks,
> Dave
>
> MFS Email system made the following annotation
> ---------------------------------------------------------------------------------------------------------------------------------------
> This email communication and any attachments may contain proprietary,
> confidential, or privileged information. If you are not the intended
> recipient, you are hereby notified that you have received this email in
> error and that any review, disclosure, dissemination, distribution or
> copying of it or its contents is prohibited. The sender does not waive
> confidentiality or any privilege by mistransmission. If you have received
> this email in error, please notify the sender immediately, delete this
> email, and destroy all copies and any attachments.
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> https://lists.ibiblio.org/mailman/listinfo/freetds




Archive powered by MHonArc 2.6.24.

Top of Page