[mapserver-dev] Performance problem with oracle spatial in mapserver 6

[Smith, Michael D ERDC-CRREL-NH]

Holger,

After looking into it a bit more, I am seeing the same drop off in
performance. I was comparing 5.2.1 to 5.6.5 and 6.0 (the versions I have
already precompiled).  For drawing 16000 points, I'm seeing it go from ~1.6
sec to 2.7 sec.

I'll do some further examinations on this (perhaps using Shark) and see what
I can figure out and hopefully, come up with a patch to resolve this.

Mike


-- 
Michael Smith
Remote Sensing/GIS Center
US Army Corps of Engineers
Hanover, NH


On 6/1/11  9:32 AM, "Holger Schiebold" <hschiebold at codematix.de> wrote:

> Hi Mike,
> 
> both datasources are point data in one view / table with srid and the
> performance problem has nothing to do with transforming or the oracle
> itself (i checked every statement). I tested it again - the only thing i
> change is mapserver binary from 5.4.0 to 5.6.4 and i can see in the
> logfile and in my wms client the performance difference. Both views /
> tables have more then 30 columns which at the end are used in the
> getFeatureInfo. But the performance problem i have already with a normal
> getMap request to the mapserver binary.
> 
> regards
> 
> Holger
> 
> 
> 
> Am 01.06.2011 12:55, schrieb Smith, Michael ERDC-CRREL-NH:
>> Holger,
>> 
>> I've done some performance testing on MapServer (a number of versions,
>> including 6) using Oracle Spatial (its our main data source) and haven't run
>> into this issue.  I'll do some checks today with some large datasets and see
>> if I can replicate the issue.
>> 
>> Are these 2d, 3d or 4d datasets? Points, lines or polygons? Do these layers
>> have defined SRIDs? Same input/output projection?
>> 
>> Mike
>> 
>> 
>