On Fri, Jan 23, 2009 at 10:08 AM, Howard Cole <howardnews@xxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
