Bill Schneider wrote: > > I've had similar experience with both Oracle BLOBs and PostgreSQL OIDs. > > Size limitation is not the only difference between LOBs and RAW columns, > though. RAW data is stored in line with the row and BLOBs are stored out of > row, meaning a LOB identifier is stored with the row and the data is stored > somewhere else. What this means is, a "select id, description from > table_with_blob" will be much faster than a "select id, description from > table_with_raw"
Oops - you are right. I just sniffed how much data is coming over the net on a simple select on a line with a 1.3MB "blob" - and it was >1.3MB.. My simple jdbc-sql-browser shows me a "[B@12345", just like with a real blob.. This indeed is a very bad thing and I will have to use a separate table for my raw-field. Thanks for the hint! -- Florian Lindauer -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
