<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3059" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=299583600-21032007><FONT face=Arial
color=#0000ff size=2>Hi Jason,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT size=2><FONT color=#0000ff><SPAN
class=299583600-21032007><FONT face=Arial color=#0000ff
size=2></FONT></SPAN></FONT></FONT></FONT> </DIV>
<DIV dir=ltr align=left><SPAN class=299583600-21032007><FONT face=Arial
color=#0000ff size=2>I have used ODBC before, and it shouldn't be too slow if
you don't have too much data. How many points are you loading in one
go?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=299583600-21032007><FONT face=Arial
color=#0000ff size=2>I notice that the data in your ODBC dataset is in the same
projection as the layer. Have you tried removing the LayerSRS statement, just in
case it's trying to re-project needlessly? </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=299583600-21032007><FONT face=Arial
color=#0000ff size=2>Also, I think you can use this:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT size=2><FONT color=#0000ff><SPAN
class=299583600-21032007><FONT face=Arial color=#0000ff
size=2></FONT></SPAN></FONT></FONT></FONT> </DIV>
<DIV dir=ltr align=left><SPAN class=299583600-21032007><FONT face=Arial
color=#0000ff size=2><SrcLayer>GIS_BLDG_PMTS</SrcLayer>
</FONT></SPAN></DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT size=2><FONT color=#0000ff><SPAN
class=299583600-21032007><FONT face=Arial color=#0000ff
size=2></FONT></SPAN></FONT></FONT></FONT> </DIV>
<DIV dir=ltr align=left><SPAN class=299583600-21032007><FONT face=Arial
color=#0000ff size=2>in stead of </FONT></SPAN></DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT size=2><FONT color=#0000ff><SPAN
class=299583600-21032007><FONT face=Arial color=#0000ff
size=2></FONT></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SrcSQL>select * from
GIS_BLDG_PMTS</SrcSQL></FONT></DIV>
<DIV> </DIV>
<DIV><SPAN class=299583600-21032007></SPAN><FONT face=Arial><FONT
color=#0000ff><FONT size=2>I<SPAN class=299583600-21032007> don't know whether
that makes any difference in performance, but worth a
try.</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=299583600-21032007></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=299583600-21032007>Regards,</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=299583600-21032007></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=299583600-21032007>Jacob</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=299583600-21032007></SPAN></FONT></FONT></FONT> </DIV>
<DIV><BR></DIV>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> chameleon-bounces@lists.maptools.org
[mailto:chameleon-bounces@lists.maptools.org] <B>On Behalf Of
</B>JBaum@townofbethlehem.org<BR><B>Sent:</B> 21 March 2007
09:31<BR><B>To:</B> chameleon@lists.maptools.org<BR><B>Subject:</B>
[Chameleon] OGRVRT performance<BR></FONT><BR></DIV>
<DIV></DIV><FONT
face="Default Sans Serif, Verdana, Arial, Helvetica, sans-serif" size=2>
<P><FONT size=2>I have successfully made a connection using the following
layer entry in my .map file:</FONT><BR><BR><FONT
size=2>#####################################################################</FONT><BR><FONT
size=2> LAYER</FONT><BR><FONT size=2> NAME
"bldpmts"</FONT><BR><FONT size=2> TYPE POINT</FONT><BR><FONT
size=2> CONNECTIONTYPE OGR</FONT><BR><FONT size=2>
CONNECTION "<OGRVRTDataSource></FONT><BR><FONT size=2>
<OGRVRTLayer name='bldpmts'></FONT><BR><FONT size=2>
<SrcDataSource>ODBC:UNAME/PWD@DNSNAME</SrcDataSource></FONT><BR><FONT
size=2> <SrcSQL>select * from
GIS_BLDG_PMTS</SrcSQL></FONT><BR><FONT size=2>
<GeometryType>wkbPoint</GeometryType></FONT><BR><FONT
size=2><SPAN style="VISIBILITY: hidden"> </SPAN>
<GeometryField encoding='PointFromColumns' x='xcoord'
y='ycoord'/></FONT><BR><FONT size=2><SPAN
style="VISIBILITY: hidden"> </SPAN>
<LayerSRS>EPSG:32115</LayerSRS></FONT><BR><FONT size=2>
</OGRVRTLayer></FONT><BR><FONT
size=2> </OGRVRTDataSource>" # the name and path to the virtual.ovf
file, </FONT><BR><FONT size=2> STATUS OFF</FONT><BR><FONT
size=2><SPAN style="VISIBILITY: hidden"> </SPAN> DATA
"bldpmts" # the name of the OGRVrtLayer</FONT><BR><FONT size=2>
PROJECTION</FONT><BR><FONT size=2>
"init=epsg:32115"</FONT><BR><FONT size=2> END</FONT><BR><FONT
size=2><SPAN style="VISIBILITY: hidden"> </SPAN>
TEMPLATE "NULL"</FONT><BR><FONT size=2> CLASS</FONT><BR><FONT
size=2><SPAN style="VISIBILITY: hidden"> </SPAN>
NAME "bldpmts"</FONT><BR><FONT size=2>
STYLE</FONT><BR><FONT size=2><SPAN
style="VISIBILITY: hidden"> </SPAN> SYMBOL
1</FONT><BR><FONT size=2> SIZE 6</FONT><BR><FONT
size=2> COLOR 255 0 0</FONT><BR><FONT size=2>
END</FONT><BR><FONT size=2> END</FONT><BR><FONT
size=2>END</FONT><BR><FONT
size=2>#######################################################</FONT><BR><BR><FONT
size=2>It takes almost 3 minutes to return a map once I turn on the layer.
I really need a faster response. </FONT><BR><BR><FONT
size=2>Does anyone have a suggestion how I can increase performance? Any
help is appreciated.</FONT></P>
<P><FONT size=2></FONT> </P>
<P><FONT size=2> </P>
<P><BR></FONT><FONT size=3>Jason Baum<BR>GIS Specialist<BR>Town of
Bethlehem<BR>445 Delaware Avenue<BR>Delmar, NY 12054<BR>518-439-4955 x1186
v<BR>518-439-5808 f</FONT><U><FONT color=#0000ff size=3><BR></FONT></U><A
href="http://maps.google.com/maps?q=445+Delaware+Ave,+Delmar,+NY"
target=blank><U><FONT color=#0000ff size=3>Map</FONT></U></A><FONT size=3>
</FONT>
</P></FONT><BR><BR><BR><BR><BR><BR>********************************************************************************************************************<BR>This
e-mail, including any attachments, is intended only for use by the
addressee(s) named herein and may contain legally privileged and/or
confidential information. If you are not the intended recipient of this
e-mail, you are hereby notified any dissemination, distribution or copying of
any part of this e-mail is strictly prohibited and may be unlawful. Please
contact the sender and permanently delete the original e-mail including
attachments.<BR>********************************************************************************************************************<BR></BLOCKQUOTE></BODY></HTML>
<table><tr><td bgcolor=#ffffff><font color=#000000>This email and any attachments are intended solely for the named recipient and are confidential. The copying or distribution of them or any information they contain by anyone other than the named recipient is prohibited. If you have received this document in error, please notify the sender and delete all copies from your computer system and destroy all hard copies. It is the recipient's responsibility to check this email and any attachments to this email for viruses before use.<br>
</font></td></tr></table>