Print Page | Close Window

Query Timeout

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce Classic
Forum Discription: For .NET 2.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=240
Printed Date: 23-May-2025 at 12:19am


Topic: Query Timeout
Posted By: Customer
Subject: Query Timeout
Date 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?


Replies:
Posted By: IdeaBlade
Date 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
about:blankIdeaBlade.Persistence~IdeaBlade.Persistence.IEntityQuery~CommandTimeout.html - CommandTimeout Gets or sets the timeout value for the command.  
about:blankIdeaBlade.Persistence~IdeaBlade.Persistence.IEntityQuery~EntityType.html - EntityType The entity type that this query returns.  
about:blankIdeaBlade.Persistence~IdeaBlade.Persistence.IEntityQuery~FindRowsResultMode.html - FindRowsResultMode Returns information regarding the behaviour of the about:blankIdeaBlade.Persistence~IdeaBlade.Persistence.IEntityQuery~FindRows.html - FindRows method call.  
about:blankIdeaBlade.Persistence~IdeaBlade.Persistence.IEntityQuery~QueryStrategy.html - 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.

 


Print Page | Close Window