Subject | Re: INSERT Speed Optimization Ideas |
---|---|
Author | robert_difalco |
Post date | 2005-06-06T13:30:55Z |
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...>
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.