Hello everybody,
I have a heatmap with 5 millions of data and this map is slow to render.
Monitoring query in postgis, the geoserver request a query with subquery to get a base64 of geometry.
SELECT “id”,encode(ST_AsEWKB(“geom”),‘base64’) as “geom”
FROM (
select * from heatmap_4531
) as vtable
Talking with our DBA, he suggested that the table heatmap_4531 contains a column that store the result of encode(ST_AsEWKB(“geom”),‘base64’) and the geoserver may use this column to make a query response more performatic but the geoserver dont support this feature.
I dont know to solve this problem. Any suggestion?
···
Att,
Arthur Zanona