Creating SVG from Shapefile, Oracle Spa tial, ArcSDE

[Smith, Michael ERDC-CRREL-NH]

You should (for Oracle spatial speed) increase the ARRAY_SIZE parameter in
maporaclespatial.c and recompile Mapserver. I would recommend ~ 100-1000.
This very important as this will dramitically reduce the number of
roundtrips between the mapserver and the database.

Mike

Mike Smith
GIS Specialist/Physical Scientist/Oracle Developer
Remote Sensing/GIS Center of Expertise
Army Engineer Research & Development Center
Hanover, NH
(603) 646-4765
michael.smith at erdc.usace.army.mil


-----Original Message-----
From: Ivano Picco [mailto:ivano.picco at AQUPI.TK]
Sent: Thursday, October 07, 2004 4:19 AM
To: MAPSERVER-USERS at LISTS.UMN.EDU
Subject: Re: [UMN_MAPSERVER-USERS] Creating SVG from Shapefile, Oracle
Spatial, ArcSDE

Yes, I have spatial indexes for all tables. I'm quite sure is not a problem
involving some kind of problem during Oracle Connection, because the OCI
driver do the same thing both on Mapserver and on Ogr2Ogr (and ogrinfo too)
and it's quite fast, also the connection trough ArcSDE is slowly than the
Shapefile access, especially during the SVG rendering test.
Maybe there's a problem with Mapserver, maybe it's my configuration.
Thanks,
Ivano picco

On Thu, 7 Oct 2004 17:29:03 +1000, Peter Bayley <pbay6343 at BIGPOND.NET.AU>
wrote:

>Have you built spatial indexes for your tables in the Oracle database?
>I use PostgreSQL and PostGIS and it's faster than Shape or TAB files
>
>Peter
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20041007/c2b7ab33/attachment.htm>