Re: [Firebird-devel] Using non-default BLOBs in Batch interface
On 11-8-2017 11:29, Dimitry Sibiryakov wrote: 11.08.2017 11:21, Alex via Firebird-devel wrote: BLOBs have hard-coded BPB which makes all BLOBs have stream type. What is advantage of stream BLOBs? You can seek stream blobs absolute (blb_seek_from_head), relative from current position (blb_seek_relative) and absolute from end (blb_seek_from_tail). IIRC for segmented blobs, only blb_seek_from_head works. I have never had a real need for those features, except to try and implements certain JDBC requirements. -- Mark Rotteveel -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Using non-default BLOBs in Batch interface
On 11.08.2017 12:29, Dimitry Sibiryakov wrote: 11.08.2017 11:21, Alex via Firebird-devel wrote: BLOBs have hard-coded BPB which makes all BLOBs have stream type. What is advantage of stream BLOBs? No disadvantages :-) Comments? BPB is not only about BLOB type, but also for using blob filters. Can your suggestion handle cases when a table has two BLOB fields of different subtypes and different filters should be applied to each of them during batch operation? Yes, it can - but requires passing same BPB for one of BLOBs for each BLOB copy. Not good. I will adjust suggestion, thank you. -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Using non-default BLOBs in Batch interface
11.08.2017 11:21, Alex via Firebird-devel wrote: BLOBs have hard-coded BPB which makes all BLOBs have stream type. What is advantage of stream BLOBs? Comments? BPB is not only about BLOB type, but also for using blob filters. Can your suggestion handle cases when a table has two BLOB fields of different subtypes and different filters should be applied to each of them during batch operation? -- WBR, SD. -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
