Unfortunately the way geoserver builds internal schemas is not ideal in that
it processes every single layer. How many feature types and how many
datastores do you have in your configuration?
Also if you can enable debug logging (go to global settings and set to
GEOTOOLS_DEVELOPER_LOGGING) and see where the query against the large layer
is taking place, that will help.
-Justin
On Fri, Aug 27, 2010 at 8:06 AM, Darren Karstens
<[email protected]>wrote:
> Hi,
> I have a few layers loaded into Geoserver (version 2.0.2) as Oracle
> datastores. When I trigger a WFS request on a paticular layer it takes
> around 7-8 seconds to get the response.
> Here is the request im sending to http://localhost:8080/geoserver/wfs:
>
> <wfs:GetFeature service="WFS" version="1.1.0"
> outputFormat="GML2"
> xmlns:wfs="http://www.opengis.net/wfs";
> xmlns:ogc="http://www.opengis.net/ogc";
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
> xsi:schemaLocation="http://www.opengis.net/wfs
> http://schemas.opengis.net/wfs/1.1.0/wfs.xsd";>
> <wfs:Query typeName="SNORFOLK:SNORFOLKLAYER466">
> <ogc:Filter>
> <PropertyIsEqualTo>
> <PropertyName>PK</PropertyName>
> <Literal>24243566</Literal>
> </PropertyIsEqualTo>
> </ogc:Filter>
> </wfs:Query>
> </wfs:GetFeature>
>
> The layer has around 1000 features and its table in Oracle has both a
> spatial index and a primary key. I have tracked the slow response down to
> another layer in another workspace in geoserver that has a huge amount of
> data. When I disable this huge layer then the WFS above completes in a
> fraction of a second instead of the previous 7-8 seconds. Is there any
> reason why the other layer is intefering with the above request? I would
> have thought that only the queried layer (SNORFOLK:SNORFOLKLAYER466) would
> be accessed in the WFS request.
> Regards
> Darren
>
>
> ------------------------------------------------------------------------------
> Sell apps to millions through the Intel(R) Atom(Tm) Developer Program
> Be part of this innovative community and reach millions of netbook users
> worldwide. Take advantage of special opportunities to increase revenue and
> speed time-to-market. Join now, and jumpstart your future.
> http://p.sf.net/sfu/intel-atom-d2d
> _______________________________________________
> Geoserver-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
------------------------------------------------------------------------------
This SF.net Dev2Dev email is sponsored by:
Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
