<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2655.35">
<TITLE>RE: [UMN_MAPSERVER-USERS] Creating SVG from Shapefile, Oracle Spatial, ArcSDE</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>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.</FONT></P>
<P><FONT SIZE=2>Mike</FONT>
</P>
<P><FONT SIZE=2>Mike Smith</FONT>
<BR><FONT SIZE=2>GIS Specialist/Physical Scientist/Oracle Developer</FONT>
<BR><FONT SIZE=2>Remote Sensing/GIS Center of Expertise</FONT>
<BR><FONT SIZE=2>Army Engineer Research & Development Center </FONT>
<BR><FONT SIZE=2>Hanover, NH</FONT>
<BR><FONT SIZE=2>(603) 646-4765</FONT>
<BR><FONT SIZE=2>michael.smith@erdc.usace.army.mil</FONT>
</P>
<BR>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Ivano Picco [<A HREF="mailto:ivano.picco@AQUPI.TK">mailto:ivano.picco@AQUPI.TK</A>] </FONT>
<BR><FONT SIZE=2>Sent: Thursday, October 07, 2004 4:19 AM</FONT>
<BR><FONT SIZE=2>To: MAPSERVER-USERS@LISTS.UMN.EDU</FONT>
<BR><FONT SIZE=2>Subject: Re: [UMN_MAPSERVER-USERS] Creating SVG from Shapefile, Oracle Spatial, ArcSDE</FONT>
</P>
<P><FONT SIZE=2>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.</FONT></P>
<P><FONT SIZE=2>Maybe there's a problem with Mapserver, maybe it's my configuration.</FONT>
<BR><FONT SIZE=2>Thanks,</FONT>
<BR><FONT SIZE=2>Ivano picco</FONT>
</P>
<P><FONT SIZE=2>On Thu, 7 Oct 2004 17:29:03 +1000, Peter Bayley <pbay6343@BIGPOND.NET.AU> wrote:</FONT>
</P>
<P><FONT SIZE=2>>Have you built spatial indexes for your tables in the Oracle database? </FONT>
<BR><FONT SIZE=2>>I use PostgreSQL and PostGIS and it's faster than Shape or TAB files</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>>Peter</FONT>
<BR><FONT SIZE=2>></FONT>
</P>
</BODY>
</HTML>