Karsten Hilbert <[EMAIL PROTECTED]> writes: > > Depends on whether you need "random access" to the contents. You can > > lo_seek() inside a large object and retrieve parts of the data with > > lo_read(), while 'text' and 'bytea' currently require fetching the > > whole file. > Not so unless I misunderstand. We use substr() on bytea for > chunking access to large files on OSs with inferior TCP/IP buffer > implementations. That's probably suboptimal performance-wise, > though.
I think the field will still be competely loaded into memory on the server side though, while LOs are stored in "chunks" and can theoretically be streamed to the client. I'm not really a definitive authority, though... -Doug ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]