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










share|improve this question






















  • 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










  • It's not clear how both components cooperate. Are they waiting for one another?
    – Gert Arnold
    Nov 11 at 14:20















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










share|improve this question






















  • 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










  • It's not clear how both components cooperate. Are they waiting for one another?
    – Gert Arnold
    Nov 11 at 14:20













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










share|improve this question













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






share|improve this question













share|improve this question











share|improve this question




share|improve this question










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 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










  • 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












  • 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 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

















active

oldest

votes











Your Answer






StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});














 

draft saved


draft discarded


















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






























active

oldest

votes













active

oldest

votes









active

oldest

votes






active

oldest

votes
















 

draft saved


draft discarded



















































 


draft saved


draft discarded














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





















































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







Popular posts from this blog

Xamarin.iOS Cant Deploy on Iphone

Glorious Revolution

Dulmage-Mendelsohn matrix decomposition in Python