Worker and external api, make web loading very slow
up vote
-1
down vote
favorite
I have two programs:
1. a software that send data all the time to an api and the api save this data into the DB
2.a web that uses a worker that runs every 500 ms and save data into the DB
they both saves the same row, different fields
when one of them works:
the web load all the data is needed to the page like it should
when both of them works:
it takes a very long time till all the data is loaded to the page
i'm using stored procedure, and EF 6
here's the code that both worker and api are using to save data:
using (DBEntities db = new DBEntities())
{
var a = db.sp_SaveScale(item.GUID, item.MAC, item.CompanyID, item.Status, item.Weight, item.WeightDate, item.Active, item.Name, item.ScalesTypeID).ToList();
if (a.Count() > 0)
item.GUID = (long)a.ElementAt(0);
}
the stored procedure 'sp_SaveScale' saves all the record
what i need to do to fix the loading problem?
I need both worker and api, to work continuously
What I have tried:
I've tried delay both worker and api but still didn't help
c# entity-framework web-worker
add a comment |
up vote
-1
down vote
favorite
I have two programs:
1. a software that send data all the time to an api and the api save this data into the DB
2.a web that uses a worker that runs every 500 ms and save data into the DB
they both saves the same row, different fields
when one of them works:
the web load all the data is needed to the page like it should
when both of them works:
it takes a very long time till all the data is loaded to the page
i'm using stored procedure, and EF 6
here's the code that both worker and api are using to save data:
using (DBEntities db = new DBEntities())
{
var a = db.sp_SaveScale(item.GUID, item.MAC, item.CompanyID, item.Status, item.Weight, item.WeightDate, item.Active, item.Name, item.ScalesTypeID).ToList();
if (a.Count() > 0)
item.GUID = (long)a.ElementAt(0);
}
the stored procedure 'sp_SaveScale' saves all the record
what i need to do to fix the loading problem?
I need both worker and api, to work continuously
What I have tried:
I've tried delay both worker and api but still didn't help
c# entity-framework web-worker
It would be awesome if you could provide a Minimal, Complete, and Verifiable example including the source code ofsp_SaveScale
.
– mjwills
Nov 11 at 9:17
As a side issue, I'd suggest usinga[0];
rather thana.ElementAt(0);
. It is much more concise.
– mjwills
Nov 11 at 9:18
It's not clear how both components cooperate. Are they waiting for one another?
– Gert Arnold
Nov 11 at 14:20
add a comment |
up vote
-1
down vote
favorite
up vote
-1
down vote
favorite
I have two programs:
1. a software that send data all the time to an api and the api save this data into the DB
2.a web that uses a worker that runs every 500 ms and save data into the DB
they both saves the same row, different fields
when one of them works:
the web load all the data is needed to the page like it should
when both of them works:
it takes a very long time till all the data is loaded to the page
i'm using stored procedure, and EF 6
here's the code that both worker and api are using to save data:
using (DBEntities db = new DBEntities())
{
var a = db.sp_SaveScale(item.GUID, item.MAC, item.CompanyID, item.Status, item.Weight, item.WeightDate, item.Active, item.Name, item.ScalesTypeID).ToList();
if (a.Count() > 0)
item.GUID = (long)a.ElementAt(0);
}
the stored procedure 'sp_SaveScale' saves all the record
what i need to do to fix the loading problem?
I need both worker and api, to work continuously
What I have tried:
I've tried delay both worker and api but still didn't help
c# entity-framework web-worker
I have two programs:
1. a software that send data all the time to an api and the api save this data into the DB
2.a web that uses a worker that runs every 500 ms and save data into the DB
they both saves the same row, different fields
when one of them works:
the web load all the data is needed to the page like it should
when both of them works:
it takes a very long time till all the data is loaded to the page
i'm using stored procedure, and EF 6
here's the code that both worker and api are using to save data:
using (DBEntities db = new DBEntities())
{
var a = db.sp_SaveScale(item.GUID, item.MAC, item.CompanyID, item.Status, item.Weight, item.WeightDate, item.Active, item.Name, item.ScalesTypeID).ToList();
if (a.Count() > 0)
item.GUID = (long)a.ElementAt(0);
}
the stored procedure 'sp_SaveScale' saves all the record
what i need to do to fix the loading problem?
I need both worker and api, to work continuously
What I have tried:
I've tried delay both worker and api but still didn't help
c# entity-framework web-worker
c# entity-framework web-worker
asked Nov 11 at 7:41
user7925257
436
436
It would be awesome if you could provide a Minimal, Complete, and Verifiable example including the source code ofsp_SaveScale
.
– mjwills
Nov 11 at 9:17
As a side issue, I'd suggest usinga[0];
rather thana.ElementAt(0);
. It is much more concise.
– mjwills
Nov 11 at 9:18
It's not clear how both components cooperate. Are they waiting for one another?
– Gert Arnold
Nov 11 at 14:20
add a comment |
It would be awesome if you could provide a Minimal, Complete, and Verifiable example including the source code ofsp_SaveScale
.
– mjwills
Nov 11 at 9:17
As a side issue, I'd suggest usinga[0];
rather thana.ElementAt(0);
. It is much more concise.
– mjwills
Nov 11 at 9:18
It's not clear how both components cooperate. Are they waiting for one another?
– Gert Arnold
Nov 11 at 14:20
It would be awesome if you could provide a Minimal, Complete, and Verifiable example including the source code of
sp_SaveScale
.– mjwills
Nov 11 at 9:17
It would be awesome if you could provide a Minimal, Complete, and Verifiable example including the source code of
sp_SaveScale
.– mjwills
Nov 11 at 9:17
As a side issue, I'd suggest using
a[0];
rather than a.ElementAt(0);
. It is much more concise.– mjwills
Nov 11 at 9:18
As a side issue, I'd suggest using
a[0];
rather than a.ElementAt(0);
. It is much more concise.– mjwills
Nov 11 at 9:18
It's not clear how both components cooperate. Are they waiting for one another?
– Gert Arnold
Nov 11 at 14:20
It's not clear how both components cooperate. Are they waiting for one another?
– Gert Arnold
Nov 11 at 14:20
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53246759%2fworker-and-external-api-make-web-loading-very-slow%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
It would be awesome if you could provide a Minimal, Complete, and Verifiable example including the source code of
sp_SaveScale
.– mjwills
Nov 11 at 9:17
As a side issue, I'd suggest using
a[0];
rather thana.ElementAt(0);
. It is much more concise.– mjwills
Nov 11 at 9:18
It's not clear how both components cooperate. Are they waiting for one another?
– Gert Arnold
Nov 11 at 14:20