Jquery ajax long waiting time

Question

0.00/5 (No votes)

See more:

I'm using jQuery ajax to call a webmethod in my asp.net page, here's the code:

JavaScript

$.ajax({
            type: 'POST',
            url: 'Home.aspx/GetPlantInfo',
            contentType: 'application/json; charset=utf-8',
            dataType: 'json',
            success: function (response) {
                info= JSON.parse(response.d);
                $("#PlantName").val(info.Name);
                .
                .
                .
            },
            failure: function (r) {
                alert(r.d);
            }
        });

the webmethod does a simple linq query and serializes the result to a JSON string, which takes less than half a sec. here's the webmethod code:

C#

    [WebMethod]
public static string GetPlantInfo()
{
    MyDataClassesDataContext dc = new  MyDataClassesDataContext();
    Plant p = (from x in dc.Plants
                   where x.Name == "someName"
                   select x).FirstOrDefault();
    string plantJson = JsonConvert.SerializeObject(p);
    return plantJson;
}

however the ajax call takes 10-15 seconds to complete. I inspected ajax timing and apparently most of this time is "Waiting" time, with negligible send and receive time. I googled this problem with no lock. What I'm asking is what exactly is this "Waiting" time? Is the problem from IIS server? is something wrong with my code?

What I have tried:

i've tried commenting the c# code so it returns an empty string, but still there is a waiting time (although it's lesser this time: 5~6 sec).

Posted 14-Jul-17 2:58am

Member 11032733

Updated 14-Jul-17 17:07pm

v2

Add a Solution

Comments

Richard Deeming 14-Jul-17 9:35am

I'd start by removing the double JSON encoding/decoding, and wrapping your context class in a using block:

[WebMethod]
public static Plant GetPlantInfo()
{
    using (var dc = new  CMMS_MyDataClassesDataContext())
    {
        return dc.Plants.FirstOrDefault(x => x.Name == "someName");
    }
}

success: function(response){
    var info = response.d;
    $("#PlantName").val(info.Name);
    ...
},

1 solution

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)

P_Z · Answer 1 · 2017-07-14T10:33:00

Oone reason that Ajax request may be "slow" is because you're retrieving the Plant object and then on Json serializing, the whole object graph ex: Plant -> LinkToPlant are also serialized. So you should specify what should be serialized ex:

C#

//create a dynamic object and select fields
 var obj = 
{
   ID = plant.ID,
   Name = plant.Name
   OtherField = plant.LinkToPlant.SomeField
};
string plantJson = JsonConvert.SerializeObject(obj);

About the Ajax code, replace "failure" (doesn't seem valid or at least I never heard of it) with "error":

$.ajax({
            failure: function (r) {
                alert(r.d);
            }
        });

to

$.ajax({
            error: function (r) {
                alert(r.d);
            }
        });