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"
If you use RAW columns you should put them in a table all by themselves with just an ID pointing to the object they're associated with. -- Bill > My solution now was mapping the Turbine-BLOB to LONG RAW in > db.props. As I understand it, the only difference is that BLOBs > can have max. 4GB, LONG RAWs only 2GB. Should be enough :) > Hope it really works in the long run. -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
