Re: [deegree-users] Timeout for accessing data source

[Martijn v. E. <ma...@ge...>]

> Hi Martijn,
>
Hi Rutger,

> Martijn van Exel wrote:
>> Hi,
>>
>> I am trying to access a quite detailed  PostGIS 3D table as input for
>> my WPVS service. Because of the amount of data in the table, I
>> regularly get timeouts:
>>
>> [14:53:54] ERROR: Exception while performing WFS-GetFeature:
>> org.deegree.ogcwebservices.OGCWebServiceException: Query timed out.
>> Datastore took too long to process the request: null
>>
>> I have put a GIST index on the table, but still..I'd like to increase
>> the timeout for the datastore reponse, where should I set this?
>
> There are actually two places you must modify:
>
> the deegreeParams sections of your WPVS and WFS configuration file  
> contain the
> element requestTimeLimit, which allows the configuration of the  
> amount of time a
> request has before it is cancelled.
>

I overlooked the WFS configuration file part! Now it's waiting for up  
to 10 mins for an answer from PostGIS. I think that could be improved  
though. In my database are 'sticks' constructed out of an ESRI ascii  
grid of 'AHN' (Actueel Hoogtebestand Nederland) data that I overlayed  
with building footprints in order to obtain a detailed 3D building  
models. The resolution of the grid is 0.5m so there is a LOT of data.
On top of that, I created simple polygons for the sticks, so that each  
3D stick actually consists of 6 simple polygon faces, again increasing  
the amount of data to be stored (and retrieved upon each WPVS  
request). That seemed to be the only way to get deegree WPVS to  
visualise this kind of data, or do you see room for optimization here?

Thanks,
Martijn


Martijn van Exel
Software Engineer
-------------------------------------
Geodan S&R
President Kennedylaan 1
1079 MB Amsterdam (NL)
-------------------------------------
Tel: +31 (0)20 - 5711 318
Fax: +31 (0)20 - 5711 333
-------------------------------------
E-mail: mar...@ge...
Website: www.geodan.nl
KvK-nummer: 33 247475
Disclaimer: www.geodan.nl/disclaimer
-------------------------------------