Restier - Entity Framework - LOADMEMORYQUERY

Question

I'm working with Restier which sits on top of the Entity Framework and Web API. When I make a call with a $top operator:

/entitySet?$top=10

The resultant query captured by the interceptor debugger is as follows:

LOADMEMORYQUERY 'SELECT * FROM [entitySet] /*EntityFramework Load MemoryQuery*/';MEMORYQUERY [entitySet] 'SELECT * FROM [entitySet] LIMIT 10'

Which ends up running the first query against the DB of:

SELECT * FROM [entitySet]

How do I avoid the LOADMEMORYQUERY call? It is a very large dataset and I would prefer to only pull from the DB what I need.

What providers are you using? as in Microsoft.Restier.Providers.InMemory — John Little, Oct 12 '18 at 06:11
CData.Salesforce 18.0.6817 - https://www.nuget.org/packages/CData.Salesforce/ — tiberriver256, Oct 13 '18 at 00:37
Can you try adding a $skip=0. the LIMIT should look like LIMIT — John Little, Oct 14 '18 at 23:00

score -2 · Answer 1 · answered Oct 13 '18 at 18:12

-2

It's radical answer, but if you want to optimize performance, it would be better to avoid using OData and most probably EF

answered Oct 13 '18 at 18:12

Aquila

1

Downvoted as this is just an opinion and not really a helpful answer for the exact question – tiberriver256 Oct 13 '18 at 18:19

1 Answers1