Re: [Firebird-devel] The IBatch Interface and inline blobs

2021-07-16 Thread Alex Peshkoff via Firebird-devel
On 7/16/21 4:54 PM, Tony Whyman wrote: So I guess that as long as the string is < 32K and you are not using a segmented blob then it is OK to use SQL_VARYING and not the inline blob facility. On the subject of limits, IBatch does seem to have a silent limit that I am still exploring. I was

Re: [Firebird-devel] The IBatch Interface and inline blobs

2021-07-16 Thread Tony Whyman
So I guess that as long as the string is < 32K and you are not using a segmented blob then it is OK to use SQL_VARYING and not the inline blob facility. On the subject of limits, IBatch does seem to have a silent limit that I am still exploring. I was comparing the time taken to insert 10

Re: [Firebird-devel] The IBatch Interface and inline blobs

2021-07-16 Thread Alex Peshkoff via Firebird-devel
On 7/16/21 12:39 PM, Tony Whyman wrote: I have recently added support for the IBatch interface to IBX and the good news that it all appears to work fine. However, I am still puzzled by why inline blobs exist. For as long as I can remember, Firebird has allowed you to over-ride the input

[Firebird-devel] The IBatch Interface and inline blobs

2021-07-16 Thread Tony Whyman
I have recently added support for the IBatch interface to IBX and the good news that it all appears to work fine. However, I am still puzzled by why inline blobs exist. For as long as I can remember, Firebird has allowed you to over-ride the input metadata SQLType to any other type that can