On Fri, Jan 23, 2009 at 10:08 AM, Howard Cole <howardnews@selestial.com> wrote:
> Hi All,
>
Hi, Howard!
> Is there some nice SQL I can use to convert a BYTEA field into large
> objects?
>
> I am having some memory problems handling bytea parameters in Npgsql -
> getting out of memory errors. From reading various posts on this I see that
> bytea's can consume much more memory than the size of the object so I am
> going to convert these bytea's to large objects so I can chunk the data.
>
About the memory issue of Npgsql, did you try to use a prepared
statement for this? We have some performance improvements when
handling bytea values but only when the NpgsqlCommand.Prepare() method
is called.
I hope it helps.
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://fxjr.blogspot.com
http://www.npgsql.org