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
------------------------------------------------------------------------------
Monitor 25 network devices or servers for free with OpManager!
OpManager is web-based network management software that monitors
network devices and physical & virtual servers, alerts via email & sms
for fault. Monitor 25 devices for free with no restriction. Download now
http://ad.doubleclick.net/ddm/clk/292181274;119417398;o
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
