On Tuesday 22 July 2003 12:35 pm, Nico Klasens wrote: > Retrieving the byte fields from the database will always require a least the > size of the blob, but that does not explain why the bytea field requires so > much memory. because the byte has to be escaped a few times and finaly has to be put in an sql statement.
the postgresql driver uses a StringBuffer and the stringbuffer doubles it's capacity every time it grows. So first the byte[] is escaped and put in a StringBuffer than the stringbuffer is inserted in the sql statement (escaped again). One other problem with using blob (iod) is when doing a export/import. because you have to use a special format (tar if i remeber correctely) that does not allow to remove the broken "check_number" function.
