Oracle performance overhead when doing SELECT on CLOB

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
domrin
Posts: 4
Joined: Fri 10 Aug 2018 09:55

Oracle performance overhead when doing SELECT on CLOB

Post by domrin » 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

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Oracle performance overhead when doing SELECT on CLOB

Post by Pinturiccio » Fri 14 Sep 2018 13:56

We will investigate the possibility to implement the InitialLobFetchSize property for .Net Core and post here when we get any results.

Post Reply