CODEWITHSUNDEEP
c#sqlamazon-web-servicesentity-framework-6
lulz
lulz

Reputation: 91

extremely Inconsistent AWS remote database query times,

I am querying for values from a database in AWS sydney, (I am in new zealand), using stopwatch i measured the query time, it is wildly inconsistent, sometimes in the 10s of milliseconds and sometimes in the hundreds of milliseconds, for the exact same query. I have no idea why.

Var device = db.things.AsQueryable().FirstOrDefault(p=>p.ThingName == model.thingName);

things table only has 5 entries, I have tried it without the asqueryable and it seems to make no difference. I am using visual studio 2013, entity framework version 6.1.1

EDIT:
Because this is for a business, I cannot put a lot of code up, another time example is that it went from 34 ms to 400 ms

thanks

Upvotes: 0

Views: 101

Answers (1)

iNovelletto
iNovelletto

Reputation: 237

This can be related to cold-warm query execution.

The very first time any query is made against a given model, the Entity Framework does a lot of work behind the scenes to load and validate the model. We frequently refer to this first query as a "cold" query. Further queries against an already loaded model are known as "warm" queries, and are much faster.

You can find more information about this in the following article: https://msdn.microsoft.com/en-us/library/hh949853(v=vs.113).aspx

One way to make sure this is the problem is to write a Stored Procedure and get data by it(using Entity Framework) to see if the problem is in the connection or in the query(Entity Framework) itself.

Upvotes: 1

Related Questions