DevForce Community Forum : Devforce & IIS Express & Large query timeouts http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Devforce & IIS Express & Large query timeouts Thu, 30 Jul 2026 00:46:28 -700 Fri, 03 Jun 2011 11:11:45 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2742 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Devforce & IIS Express & Large query timeouts : PompomJuice, I wish I could... http://www.ideablade.com/forum/forum_posts.asp?TID=2742&PID=10891#10891 Author: robertg
Subject: 2742
Posted: 03-Jun-2011 at 11:11am

PompomJuice,

I wish I could just make it go away! Unfortunately, it's not a DevForce problem, so I can just provide some advice.

It seems to me that you can approach this in two directions. You can either increase time timeout settings for IIS Express so it can handle the wait, or you can optimize your query so that it doesn't take as long, and you don't get to the timeout.

For speeding up your query, the first thing I would recommend is to take a look at the query performance article in the DRC: http://drc.ideablade.com/xwiki/bin/view/Documentation/query-performance. In particular, you might want to make sure that you're limiting your includes (which give the query an awful lot more work to do), or replace your current query with an asynchronous query, that brings down chunks of data at a time and thus prevents timeout. You may also choose to limit the amount of data you're querying into your entity with an anonymous projection: http://drc.ideablade.com/xwiki/bin/view/Documentation/query-anonymous-projections.

There are other things you could look into-- such as optimizing the underlying database for queries such as the one that you're running-- but I think that the IIS configuration and query performance steps should resolve your problem.

-- Robert
]]> Fri, 03 Jun 2011 11:11:45 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2742&PID=10891#10891 Devforce & IIS Express & Large query timeouts : Hi,IIS Express has some sort of... http://www.ideablade.com/forum/forum_posts.asp?TID=2742&PID=10889#10889 Author: pompomJuice
Subject: 2742
Posted: 03-Jun-2011 at 1:14am

Hi,

IIS Express has some sort of issue with large queries. (~60K+ rows/~30 second query)

There comes a point where they will just time out, and none of your query time-out suggestions work. (ASP.NET Development Server just works) 

Please figure out and make it go away please :)

W
]]> Fri, 03 Jun 2011 01:14:38 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2742&PID=10889#10889