Hi,
I've recently started using GeoServer and built a small prototype to evaluate
its performance and features to evaluate if GeoServer could be a viable
solution for our project. I ran into some issues that I hope you can help me
solve.
I've been running GeoServer 2.2.4 and PostGIS 2.0.1 (on top of PostGres 9.2) on
a Windows machine.
In our project the user has the ability to create temporary tables and/or
columns dynamically. Example: The user wants the "States" table to have a
dynamically calculated "Clients per State" column. These datasets are temporary
and disappear after the user has logged out. Does GeoServer have any kind of
mechanism to help me with temporary datasets? If not, how would you advise me
to implement it?
I did a couple of simple performance tests with GeoServer and a Local PostGIS
database and the results were pretty good. A cross layer spatial intersection
(around 350k geometries) took around 8 seconds which is a pretty okay. When I
tested with a remote PostGIS database the same test took around 6 minutes. I'm
unsure if latency is enough of a factor to justify such a difference and I
would like to know if there is anything I can tune to improve this performance.
I found this issue to be very awkward since I feel that network alone doesn't
justify my problem.
Many thanks in advance!
Cosme Benito
------------------------------------------------------------------------------
Symantec Endpoint Protection 12 positioned as A LEADER in The Forrester
Wave(TM): Endpoint Security, Q1 2013 and "remains a good choice" in the
endpoint security space. For insight on selecting the right partner to
tackle endpoint security challenges, access the full report.
http://p.sf.net/sfu/symantec-dev2dev
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
