Oracle performance overhead when doing SELECT on CLOB
Posted: Thu 13 Sep 2018 11:00
Hi,
We're experiencing an issue where including a CLOB field in a SELECT doubles the query response time.
Seeing as the CLOBs we are accessing are quite small, it seems like we might benefit from using the InitialLobFetchSize property on OracleCommand as specified in an update here: viewtopic.php?t=31098 as it was floated as a solution in this thread - viewtopic.php?f=1&t=22779&p=76552&hilit ... ize#p76552
However, we are using entity framework core and cannot find any way to access/set this property so that it is used in our dbcontext.
Can anyone advise on how to do this?
Thanks,
Dom
We're experiencing an issue where including a CLOB field in a SELECT doubles the query response time.
Seeing as the CLOBs we are accessing are quite small, it seems like we might benefit from using the InitialLobFetchSize property on OracleCommand as specified in an update here: viewtopic.php?t=31098 as it was floated as a solution in this thread - viewtopic.php?f=1&t=22779&p=76552&hilit ... ize#p76552
However, we are using entity framework core and cannot find any way to access/set this property so that it is used in our dbcontext.
Can anyone advise on how to do this?
Thanks,
Dom