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
Oracle performance overhead when doing SELECT on CLOB
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Oracle performance overhead when doing SELECT on CLOB
We will investigate the possibility to implement the InitialLobFetchSize property for .Net Core and post here when we get any results.