DevForce Community Forum : Query Timeout http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : Query Timeout Sun, 12 Apr 2026 23:18:09 -700 Thu, 12 Jul 2007 17:35:26 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=240 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Query Timeout : You can increase the timeout value.... http://www.ideablade.com/forum/forum_posts.asp?TID=240&PID=531#531 Author: IdeaBlade
Subject: 240
Posted: 12-Jul-2007 at 5:35pm

You can increase the timeout value. One of the properties of any query is CommandTimeout,  See Reference Help regarding the IEntityQuery interface.. Public Properties
 NameDescription
CommandTimeoutGets or sets the timeout value for the command.  
EntityTypeThe entity type that this query returns.  
FindRowsResultModeReturns information regarding the behaviour of the FindRows method call.  
QueryStrategy

Determines whether this query will operate against the data source, the in-memory cache, or a combination of the two.  


If you want to avoid such timeout, you should try to break down some of the more complicated span queries into several smaller separate span queries.

Assuming you have 3 different relationships to the current entity table, you would normally create a span query with 3 separate AddSpan clauses to retrieve data from all 4 tables.  You could try to break them up into 3 separate span queries instead.

 

]]> Thu, 12 Jul 2007 17:35:26 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=240&PID=531#531 Query Timeout : I have a query that generates... http://www.ideablade.com/forum/forum_posts.asp?TID=240&PID=530#530 Author: Customer
Subject: 240
Posted: 12-Jul-2007 at 5:32pm

I have a query that generates a timeout due to all the query spans I use.  Is there a way to increase the timeout threshold or possibly make the query spans a bit more efficient?

]]> Thu, 12 Jul 2007 17:32:55 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=240&PID=530#530