How to reduce the time in saving the data in web application

Question

0.00/5 (No votes)

See more:

Dear all,

I have a web application which is hosted on remote server and sql server 2012 is installed ove there only. i access the application from some other system over internet. When i do some changes and save the data it takes too much time. How to reduce the time in saving the data.

Regards,
Venga

Posted 11-Jun-14 19:22pm

mvengaqua

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Raul Iloc · Accepted Answer · 2014-06-11T20:07:00

In the web application, the user is using a web page with input controls, where the user enter its inputs and then press a "Save" (summit) button. So I see two place of improvement:

1. Because each time time when a summit button is pressed, the entire web page with all its content is send it back to the web server (where the web application is executed), you could optimize this, by using jQuery and AJAX call and by sending only the values of the user inputs.

2. On the server code, when the "Save" method invoked via jQuery and AJAX, you have just to search on the database via ID (or the current entity primary key) the entity that has to be save, then set the values that come as parameter (that should contain the user inputs), and finally save it into the database. To to this you could use Entity Framework, or ADO.NET with stored procedure or SQL commands with parameters.

TrushnaK · Accepted Answer · 2014-06-11T19:28:00

Solution 1

From your question we can't judge the code where your time gets consume.
So, for to develop optimum site you should remember some points.

See below links:-
ASP.NET Optimization[^]
http://msdn.microsoft.com/en-us/library/aa719563(v=vs.71).aspx[^]
http://msdn.microsoft.com/en-us/library/5dws599a(v=vs.71).aspx[^]

or debug your code and find out where it takes more time and post again.

Posted 11-Jun-14 19:28pm

TrushnaK

Comments

mvengaqua 12-Jun-14 1:41am

the moment i go for saving or updating the data it takes time.

Thava Rajan 12-Jun-14 3:30am

it also depend upon your network speed too

**Nirav Prabtani** · Accepted Answer · 2014-06-11T19:44:00

Solution 2

try to improve your sql query performance, you can find tutorials and guidelines on google.. :)
read this.. :)

Query Performance Tuning (SQL Server Compact)[^]

7 performance tips for faster SQL queries[^]

Improving Query Performance[^]

10 Ways to Improve SQL Query Performance[^]

Posted 11-Jun-14 19:44pm

Nirav Prabtani