Subject Re: INSERT Speed Optimization Ideas
Author robert_difalco
That is well understood. 2048 was chosen as an average size of my
posted data. Once the data gets larger than that, it is sent to the
"fallback" BLOB instead. I'd like to keep the VARCHAR smaller than 32k
since it is stored in its declared lenghth in memory. I also believe
that in FB 1.0.3 the VARCHAR is sent over the wire in its full
declared length.

--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
> you seem to be thinking that 2048 is a varchar limit? - AFAIK, you
> could make the Varchar field 32000 if you really want.