How to optimize multiple $.ajax({...}) function loading in Asp.net?

Question

I calling multiple function on page load in my asp.net web application.

All function run on page ready method see the below code

 $(document).ready(function(){
     func1();
     func2();
     func3();
    //....  so on.
    });
    function func1()
    {
    $.ajax({
     type: "POST",
      url: "Contents.asmx/GetText",
      data: "{ }",
      contentType: "application/json; charset=utf-8",
      dataType: "json",
      success: function (msg) {
            /some code
      }
    });
    }

    function func2()
    {
    $.ajax({
     type: "POST",
      url: "Contents.asmx/GetTitles",
      data: "{ }",
      contentType: "application/json; charset=utf-8",
      dataType: "json",
      success: function (msg) {
            /some code
      }
    });
    }

.... like wise others

For backend I using SQL server-05. When page is loading It getting more time to load, above functions takes 30+ seconds to load.

How to optimze function calling?..

So where do you think the delay is? In your javascript, the server or the SQL server? — Lazarus
– Lazarus, Commented Jun 10, 2011 at 11:08
Well, try optimizing your queries. Maybe even use caching to avoid hitting the DB server all the time if those queries are expensive. — Darin Dimitrov
– Darin Dimitrov, Commented Jun 10, 2011 at 11:09
In javascript. All method call some of SQL functions at a time. so the issues comes. — Abhishek B.
– Abhishek B., Commented Jun 10, 2011 at 11:09
any other way to optimize Javascript calling. If there is no issues in SQL Query. then ?? — Abhishek B.
– Abhishek B., Commented Jun 10, 2011 at 11:11

Darin Dimitrov · Accepted Answer · 2011-06-10 11:14:31Z

1

You could aggregate all the queries into a new web method which will perform all the SQL queries at once. Then send a single AJAX request to this new method. And as far as your SQL server is concerned you could also send multiple SQL queries into a single round-trip. Try optimizing the SQL queries as much as possible. Also you could cache the results of some expensive queries.

answered Jun 10, 2011 at 11:14

Darin Dimitrov

1.0m277 gold badges3.3k silver badges3k bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Darin Dimitrov Over a year ago

@Abhishek, what have you tried? What issues are you encountering?

Abhishek B. Over a year ago

I checking Stored procedures but in my local PC it working fine on live server it getting more time to execute...

Kissaki · Accepted Answer · 2011-06-10 11:12:36Z

1

As long as /some code is not too much there is not really much you can do. These ajax calls area light-weight. Your problem is probably in the backend, where you send your requests to.

To debug/profile your problem, first check your ajax requests. Check them in a web-tool like Firebug and see that your request is expected. There you can also check which of your requests takes how long.

As you now see your bottleneck (e.g. requesting Contents.asmx/GetTitles is what takes so long), check your server that provides that page. As you did not provide code of that one, we can not help you there. But that’s where you have to look for next.

answered Jun 10, 2011 at 11:12

Kissaki

9,3355 gold badges43 silver badges46 bronze badges

Collectives™ on Stack Overflow

How to optimize multiple $.ajax({...}) function loading in Asp.net?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related