Thanks for the comments, a few things for me to investigate, I'll try using a shape file and also add some metrics to the clipping (I'm already running a slightly modified version of geoserver).
Also glad to hear it's common to chop up large polygons like I was thinking. Kind Regards, Vic ________________________________ From: [email protected] [[email protected]] on behalf of Andrea Aime [[email protected]] Sent: 09 August 2015 20:25 To: Martin Davis Cc: Kirk, Victor; [email protected] Subject: Re: [Geoserver-users] Performance issue with large polygon On Sun, Aug 9, 2015 at 5:19 PM, Martin Davis <[email protected]<mailto:[email protected]>> wrote: AFAIK there is no way to cache a layer in memory. This would be a useful feature to add to GeoServer. Perhaps you could cache the geometry as a shapefile - which should provide fastest performance off disk? It would be interesting to see what the performance boost is at any rate. I also wonder if clipping small parts out of a very large geometry is causing a performance hit. We have a fast rectangular clipping algorithm geared towards rendering that is significantly faster than JTS intersection (as we don't require the result to be topologically valid, which greatly simplifies things). It could still be that it's clipping, mind, but there are other possible issues in play, besides the obvious data transfer cost, which is going to be high regardless, if the DB is postgis, loading from tables with large polygons might result in the spatial index not being used at all: http://postgis.net/docs/performance_tips.html#small_tables_large_objects Other spatial databases might have their own specific issues against geometries with large number of vertices. Cheers Andrea -- == GeoServer Professional Services from the experts! Visit http://goo.gl/it488V for more information. == Ing. Andrea Aime @geowolf Technical Lead GeoSolutions S.A.S. Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549 http://www.geo-solutions.it http://twitter.com/geosolutions_it AVVERTENZE AI SENSI DEL D.Lgs. 196/2003 Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il loro utilizzo è consentito esclusivamente al destinatario del messaggio, per le finalità indicate nel messaggio stesso. Qualora riceviate questo messaggio senza esserne il destinatario, Vi preghiamo cortesemente di darcene notizia via e-mail e di procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso, divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità diverse, costituisce comportamento contrario ai principi dettati dal D.Lgs. 196/2003. The information in this message and/or attachments, is intended solely for the attention and use of the named addressee(s) and may be confidential or proprietary in nature or covered by the provisions of privacy act (Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection Code).Any use not in accord with its purpose, any disclosure, reproduction, copying, distribution, or either dissemination, either whole or partial, is strictly forbidden except previous formal approval of the named addressee(s). If you are not the intended recipient, please contact immediately the sender by telephone, fax or e-mail and delete the information in this message that has been received in error. The sender does not give any warranty or accept liability as the content, accuracy or completeness of sent messages and accepts no responsibility for changes made after they were sent or for other risks which arise as a result of e-mail transmission, viruses, etc. -------------------------------------------------------
------------------------------------------------------------------------------
_______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
