Florian Lindauer <[EMAIL PROTECTED]> writes: > 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!
Is there any Torque change that needs to come out of this discussion? -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
