New Posts New Posts RSS Feed: Query Timeout
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

Query Timeout
 Post Reply Post Reply
Author
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
Customer View Drop Down
Senior Member
Senior Member
Avatar
User Submitted Questions to Support

Joined: 30-May-2007
Location: United States
Posts: 260 		Post Options Post Options   Quote Customer Quote  Post ReplyReply Direct Link To This Post Topic: Query Timeout
    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?
Back to Top
IdeaBlade View Drop Down
Moderator Group
Moderator Group
Avatar

Joined: 30-May-2007
Location: United States
Posts: 353 		Post Options Post Options   Quote IdeaBlade Quote  Post ReplyReply Direct Link To This Post 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
  Name Description
CommandTimeout Gets or sets the timeout value for the command.  
EntityType The entity type that this query returns.  
FindRowsResultMode Returns 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.

 
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down