[MapServer-users] Cluster with Oracle Spatial data

[Holger Schiebold]

Hi Ivan,

sounds strange. How many features are in your datasource to be 
clustered? Do you see any load on your mapserver machine when you make a 
request?

Maybe that's a special case with your oracle data. Would you show as 
your mapfile - or the relevant parts?

The cluster option was developed by Tamas Szekeres in 2011 espacially 
for the service i noticed in my last answer. We were involved in the 
testing and maintained the service for a few years and had no special 
problem with oracle data and the cluster option. But it's a long time 
ago and maybe in newer version there is a problem.  Generally i agree 
with Jeff - this should work with every datasource.

Regards Holger



Am 12.10.2023 um 09:02 schrieb Yankov, Ivan via MapServer-users:
> Hi Holger,
>
> thanks for your feedback. All my services use the Oracle Spatial database, so there is no problem with the general connection to the database.
> Its just that the cluster option doesn’t work for me when I use Oracle as datasource.
>
> The shape-layer that I described was only for test purposes because I wanted to see if I can get the cluster feature working at all.
> There seemed to be no issues with a shape source. The problem occurs only when I use my default datasource, which in my case is Oracle Spatial.
>
> Regards
> Ivan
>
> -----Ursprüngliche Nachricht-----
> Von: MapServer-users <mapserver-users-bounces at lists.osgeo.org> Im Auftrag von Holger Schiebold via MapServer-users
> Gesendet: Mittwoch, 11. Oktober 2023 10:08
> An: mapserver-users at lists.osgeo.org
> Betreff: Re: [MapServer-users] Cluster with Oracle Spatial data
>
> Yes, that should not be a problem with oracle spatial and cluster.
> Generally this works.
> (https://via.bund.de/wsv/wadaba/www/wms?REQUEST=GetCapabilities&SERVICE=WMS&VERSION=1.3.0)
> This service works with cluster and oracle spatial data. ( an older service and a bit slow - the problem we had with cluster option and some more features was primarily the performance) I would test if your oracle features are shown without cluster option first. Maybe it's a problem with your oracle connection setup first.
>
> regards Holger
>
> Am 10.10.2023 um 21:12 schrieb Jeff McKenna via MapServer-users:
>> Hi Ivan,
>>
>> I believe this should work with any database or OGR connection (I
>> think my initial tests, for the docs, were with an OGR/KML connection,
>> but I remember testing SpatiaLite later as well for cluster).
>>
>> (I'll see if I can test this with Oracle, but, it may take me a while
>> to setup, so someone else might have to jump in & help you here)
>>
>> -jeff
>>
>>
>>
>>
>>
>>
> mit freundlichen Grüßen
>
> --
> Holger Schiebold
>
>
> ____________________
> codematix GmbH
> Felsbachstrasse 5/7
> D-07745 Jena
> Tel. +49 (3641) 3038-18
> www.codematix.de
>
> _______________________________________________
> MapServer-users mailing list
> MapServer-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapserver-users
> _______________________________________________
> MapServer-users mailing list
> MapServer-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapserver-users


mit freundlichen Grüßen

-- 
Holger Schiebold


____________________
codematix GmbH
Felsbachstrasse 5/7
D-07745 Jena
Tel. +49 (3641) 3038-18
www.codematix.de