S
steve pittman
Guest
On 10/16/2014 12:23 PM, cverbiest wrote: RE: 10.2B08: Option auto adjustment sql-width available? Reply by cverbiest 1. Maybe a stupid question : Are there drawbacks to setting _sql-width to 32768 on all character fields ? The real maximum is lower so you'd never had to update _sql-width again. Stop receiving emails on this subject. Flag this post as spam/abuse. Yes, there are drawbacks! This has been tried and has very significant performance impact. Also, applications like Crystal make fomat and display decisions based on these sizes. The server does buffer allocation based on defined sql widths, and allocates buffers for the number of output rows per network msg (default = 50). The numbers multiple out to big values, giving very large data buffers, mostly unused. So, it leads to a large memory footprint, more paging, less locality of reference, etc. So, it might work OK with just a very few fields, but is quite problem prone. ....steve pittman [OE sql architect]
Continue reading...
Continue reading...