Reputation: 1770
it might be a bit off topic but i am looking for some rules how to optimize the speed of a web service. At the moment i am getting a response time of 12 to 18 seconds. The web service connected to 1 database but gets data from 3 different tables. I noticed that if i connect to 1 table my speed is about 2 seconds to get all the data.
Is there some documentation available that can help me on my way to optimize perhaps the web service (or even the database) to gain most of it's speed?
Some questions in this case:
thanks
Upvotes: 0
Views: 1187
Reputation: 18387
You need a way to identify the bottleneck. As you're hosting on Azure, you can try Glipse: (at http://getglimpse.com )
A tip:
-run your queries against your database and enable a profiler / execution plan to check if there's a missing index. Try to write your query in a different way and compare the execution plan to see if there's any improvement.
Upvotes: 1