J Jeff81 Member³ May 21, 2021 #1 Version 14 started with a new feature of: CLOBs and BLOBs are now fetched on demand to improve query performance. This used to work but not I am running 14.0.6.1988 and I am noticing that blobs are being fetched with the query, no longer on demand.
Version 14 started with a new feature of: CLOBs and BLOBs are now fetched on demand to improve query performance. This used to work but not I am running 14.0.6.1988 and I am noticing that blobs are being fetched with the query, no longer on demand.
J Jeff81 Member³ May 24, 2021 #1 I select from a table that has a BLOB in every column. After I return a certain number of errors I get the message about "Result set exceeds teh maximum size (100 MB)" At one point I stopped getting this message
I select from a table that has a BLOB in every column. After I return a certain number of errors I get the message about "Result set exceeds teh maximum size (100 MB)" At one point I stopped getting this message
Marco Kalter Administrator Staff member May 25, 2021 #1 Can you let me know how many rows had been fetched at this point, and how many BLOB columns are in each row?
Can you let me know how many rows had been fetched at this point, and how many BLOB columns are in each row?
J Jeff81 Member³ May 25, 2021 #1 I get 11,088 rows return with 1 blob in each row. Interesting is that the total size of all blobs in these rows is 977mb.
I get 11,088 rows return with 1 blob in each row. Interesting is that the total size of all blobs in these rows is 977mb.
F fabrice Member³ May 26, 2021 #1 Is option "Fetch clob and blob on demand" check in sql window preference screen?
