On Sat, 19 Nov 2011, Reinier Olislagers wrote:
Hi list, The Firebird/Interbase ibconnection.pp code has this code in its SetParameters procedure to upload blobs in segments (BlobSegmentSize property is set to 80 on object creation): while BlobBytesWritten < (BlobSize-BlobSegmentSize) do begin isc_put_segment(@FStatus[0], @blobHandle, BlobSegmentSize, @s[(i*BlobSegmentSize)+1]); inc(BlobBytesWritten,BlobSegmentSize); inc(i); end; if BlobBytesWritten <> BlobSize then isc_put_segment(@FStatus[0], @blobHandle, BlobSize-BlobBytesWritten, @s[(i*BlobSegmentSize)+1]); I've asked the Firebird list whether we need to upload in segments and the answer is no, you can upload in chunks of up to 65535 bytes (see below). Would getting rid of the BlobSegmentSize property and replacing it by a BlobSegmentSize const set at 65535 make sense (e.g. for performance)?
Well, if Ann Harrison herself says it's irrelevant, then yes. I suspect it would indeed give a serious performance boost :)
Michael. _______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal