Hi. Thanks for the answer. That is our plan B, actually. I just wanted to know the reason for the performance to be so bad after labelling, because I've been unable to find any logical explanation so far.
Best regards. Óscar Diago Alonso Ingeniero GIS (+34) 945 13 13 72 | Plza. del Renacimiento, 9, 2.ª planta, Oficina 2 - 01004 Vitoria-Gasteiz De: Humphries, Graham <graham.humphr...@stategrowth.tas.gov.au> Enviado el: martes, 16 de abril de 2024 1:00 Para: Oscar Diago Alonso <oscar.di...@geograma.com>; geoserver-users@lists.sourceforge.net Asunto: [EXTERNO] RE: Issue with poor performance after labelling a layer No suele recibir correos electrónicos de graham.humphr...@stategrowth.tas.gov.au<mailto:graham.humphr...@stategrowth.tas.gov.au>. Por qué esto es importante<https://aka.ms/LearnAboutSenderIdentification> If you need to have the labels it those exact locations, then you could publish the layer again as point layer using the geometry attribute for the label position. The Geoserver documentation for the SLD cookbook is extensive and has plenty of examples that you might find useful Cheers, Graham H From: Oscar Diago Alonso via Geoserver-users <geoserver-users@lists.sourceforge.net<mailto:geoserver-users@lists.sourceforge.net>> Sent: Monday, April 15, 2024 3:22 PM To: geoserver-users@lists.sourceforge.net<mailto:geoserver-users@lists.sourceforge.net> Subject: [Geoserver-users] Issue with poor performance after labelling a layer Good morning. I have a layer with two geometry attributes: one is to store a line and the other has the position of its label. If I do an SLD to symbolize just the line it works fine. When I add the label without indicating the attribute of its position, the layer works fine, too. But after adding that the label should be displayed in the position of that second geometry field, the performance plummets and I don't know why. Both fields have spatial indexes and use the same coordinate system. The table is stored in an Oracle database, so I made sure both fields are registered in the USER_SDO_GEOM_METADATA. The data comes from a view of a view. The GeoServer is 2.24.2. The style is very simple: <LineSymbolizer> [...] </LineSymbolizer> <TextSymbolizer> <Geoemtry> <PropertyName>ETIQUETA</PropetyName> </Geometry> <Label> <PropertyName>ETIQUETA_TEXT</PropetyName> </Label> [...] </TextSymbolizer> Does anyone have any idea of what could be happening? What am I doing wrong? Thanks for any help provided. Best regards. Óscar Diago Alonso - Ingeniero GIS (+34) 945 13 13 72 | Plza. del Renacimiento, 9, 2.ª planta, Oficina 2 - 01004 Vitoria-Gasteiz [https://geograma.com/wp-content/banners/05042024.png]<https://www.linkedin.com/company/geograma/> Si no ves la imagen puedes acceder desde aquí<https://www.linkedin.com/company/geograma/> Esta comunicación contiene información de acceso restringido y de uso exclusivo del destinatario. Si usted no es el destinatario tenga en cuenta que cualquier distribución, copia o uso de esta comunicación o la información que contiene está estrictamente prohibida. Si usted ha recibido esta comunicación por error por favor notifíquelo en la dirección d...@geograma.com<mailto:d...@geograma.com>. Tratamos su dirección de correo electrónico y otros datos personales para mantener el contacto y comunicación con Ud. y, en su caso, remitirle información sobre nuestros productos y servicios. Si no desea recibir tal información envíe un e-mail en tal sentido a d...@geograma.com<mailto:d...@geograma.com>. Puede acceder, rectificar y suprimir los datos, así como otros derechos, como se detalla en la información adicional y completa a su disposición en nuestra política de privacidad en la URL www.geograma.com/politica-privacidad/<http://www.geograma.com/politica-privacidad/> [https://geograma.com/wp-content/banners/web.png]<https://www.geograma.com/> [https://geograma.com/wp-content/banners/in.png] <http://geograma.com/wp-content/eventos/linkedin.php> ________________________________ CONFIDENTIALITY NOTICE AND DISCLAIMER The information in this transmission may be confidential and/or protected by legal professional privilege, and is intended only for the person or persons to whom it is addressed. If you are not such a person, you are warned that any disclosure, copying or dissemination of the information is unauthorised. If you have received the transmission in error, please immediately contact this office by telephone, fax or email, to inform us of the error and to enable arrangements to be made for the destruction of the transmission, or its return at our cost. No liability is accepted for any unauthorised use of the information contained in this transmission.
_______________________________________________ Geoserver-users mailing list Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users