[Chameleon] OGRVRT performance

[Delfos, Jacob]

Hi Jason,
 
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?
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? 
Also, I think you can use this:
 
<SrcLayer>GIS_BLDG_PMTS</SrcLayer> 
 
in stead of 
 
<SrcSQL>select * from GIS_BLDG_PMTS</SrcSQL>
 
I don't know whether that makes any difference in performance, but worth
a try.
 
Regards,
 
Jacob
 


________________________________

	From: chameleon-bounces at lists.maptools.org
[mailto:chameleon-bounces at lists.maptools.org] On Behalf Of
JBaum at townofbethlehem.org
	Sent: 21 March 2007 09:31
	To: chameleon at lists.maptools.org
	Subject: [Chameleon] OGRVRT performance
	
	
	I have successfully made a connection using the following layer
entry in my .map file:
	
	
#####################################################################
	  LAYER
	    NAME "bldpmts"
	    TYPE POINT
	    CONNECTIONTYPE OGR
	    CONNECTION "<OGRVRTDataSource>
	     <OGRVRTLayer name='bldpmts'>
	        <SrcDataSource>ODBC:UNAME/PWD at DNSNAME</SrcDataSource>
	        <SrcSQL>select * from GIS_BLDG_PMTS</SrcSQL>
	        <GeometryType>wkbPoint</GeometryType>
	     <GeometryField encoding='PointFromColumns' x='xcoord'
y='ycoord'/>
	     <LayerSRS>EPSG:32115</LayerSRS>
	    </OGRVRTLayer>
	 </OGRVRTDataSource>" # the name and path to the virtual.ovf
file, 
	    STATUS OFF
	     DATA "bldpmts" # the name of the OGRVrtLayer
	    PROJECTION
	      "init=epsg:32115"
	    END
	     TEMPLATE "NULL"
	    CLASS
	      NAME "bldpmts"
	      STYLE
	       SYMBOL 1
	       SIZE 6
	       COLOR 255 0 0
	      END
	    END
	END
	#######################################################
	
	It takes almost 3 minutes to return a map once I turn on the
layer.  I really need a faster response.  
	
	Does anyone have a suggestion how I can increase performance?
Any help is appreciated.

	 

	 

	
	Jason Baum
	GIS Specialist
	Town of Bethlehem
	445 Delaware Avenue
	Delmar, NY 12054
	518-439-4955 x1186 v
	518-439-5808 f
	Map <http://maps.google.com/maps?q=445+Delaware+Ave,+Delmar,+NY>








	
************************************************************************
********************************************
	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.
	
************************************************************************
********************************************
	



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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/chameleon/attachments/20070321/7256c0d2/attachment.html