Search code examples
ado.netoracle11gentity-framework-5odp.netado.net-entity-data-model

Setting fetch size in entity framework

I am converting ado.net code to use EF. In my ado.net code i set dataReader.FetchSize = command.RowSize * 1000 and that dramatically improves performance over the default fetch size . When I convert my code to EF, the performance is on par to ado.net code where I didn't specify fetch size, i.e. it's very slow over large records.

Any way I could specify fetch size for retrieving records in EF?

Solution

  • You can set ODP.NET FetchSize in the Registry or the .NET config files when using Entity Framework. That will standardize the FetchSize across all your ODP.NET instances (in the case of the Registry) or across your application (in the case of app/web.config).

    http://docs.oracle.com/cd/E48297_01/doc/win.121/e41125/featConfig.htm

    Christian Shay

    Oracle