Hello!
Hope anybody can help in improving the response time for a WMS working on a PostGIS table with 1 million point spread around Italy. The viewer use leaflet and consumes the layer as WMS. The system was developer to display over a website but now I need to display over a 55 inch touch screen completely offline. I setup a Virtualbox machine and use that as a local server. The virtual machine uses 8Gb of the total 16GB, the processor is an i7.
Each point of the layer has the same symbol generated from an image icon. The layer is displayed for layers greater than 12 and the first tile load takes 12 to 15 seconds, then it gets quicker to represent tiles. The points are on a PostGIS layer, spatial index built.
The geometry of the original table is 4326, the display is over OSM.
I tried to follow some of the hints for improving the performance of the server, and it is better than the beginning, but I think there is still room for improvements.
Using precaching might become complicated because the map might request WMS with some filter expression during the requests on that layer.
Any help, idea or suggestion is welcome.
Cheers.
Simone
 |
|---|
| Simone Gadenz BEECOME S.R.L. Via Sansedoni 7, 53100 SIENA - ITALY Phone/Fax: +39 0577 588408 www.beecome.it simone@anonymised.com |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Informativa Privacy - Ai sensi del D. Lgs n. 196/2003 (Codice Privacy) si precisa che le informazioni contenute in questo messaggio sono riservate e ad uso esclusivo del destinatario. Qualora il messaggio in parola Le fosse pervenuto per errore, La preghiamo di eliminarlo senza copiarlo e di non inoltrarlo a terzi, dandocene gentilmente comunicazione. Grazie. Privacy Information - This message, for the D. Lgs n. 196/2003 (Privacy Code), may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. |