Inserting a record from UI event is delayed and executed at last second

Shrinivas Sarmane asked on June 13, 2020 19:34

Hi Everyone,

We have developed an ASP C# website in Kentico 10. We have an issue - When we click on a button on UI to save/insert a record, then it takes 7-8 seconds to come back.

We observed that in last 7th or 8th second the database insert operation gets performed. So we would like to know what happens in first 6 seconds. Is there any possibility that something is running in Kentico? Whats wrong happening here? Almost for all other operations we have observed the same.

  1. UI Code <ucsfl:SaveForLater runat="server" ID="savedForLater" />

  2. Button code <asp:LinkButton CssClass="save-for-later-btn" runat="server" ID="LnkSaveForLater" OnClick="LnkSaveForLater_Click" ValidationGroup="savedformore"> Save for Later</asp:LinkButton>

  3. Backend C# code Insert query to fire on DB with values from UI. After 6 seconds we see record in DB and then on 7th second we get response on UI.

Looking forward for your support for this issue.

Thanks Shrinivas

Recent Answers

Brenden Kehren answered on June 13, 2020 20:10

This could be a number of things:

Let's start by assuming you're doing this insert on the Form tab.

  • What are your web server and database server specs?
  • Have you had or made any network changes?
  • Do you have any custom code?
  • How big is your database?
  • Have you run the Kentico KInspector on your site?
0 votesVote for this answer Mark as a Correct answer

Shrinivas Sarmane answered on June 13, 2020 20:21

I have added code snippet in question. * Web server and db server running on 16GB machine. Its running on my local machine. 16GB ram. * No network changes. I am trying everything on local * Yes the code is custom code. UI & backend code * 5GB of database size * Yes we have Kentico Kinspector on site

0 votesVote for this answer Mark as a Correct answer

Brenden Kehren answered on June 13, 2020 20:23

Ok what did KInspector state? Follow the directions there and see what it suggests.

0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.