[Gdal-dev] OGR VRT performance through ODBC...

[John Cole]

Frank,
  Running ogrinfo takes more than 2 seconds to return a few rows (<10),
though I'm not doing any precise timing.  I didn't see an option to print
out any performance statistics.

I was hoping there might be some tuning I could do on the ODBC driver to
improve the speed.

Thanks,

John

-----Original Message-----
From: Frank Warmerdam [mailto:warmerdam at pobox.com] 
Sent: Saturday, March 17, 2007 1:54 PM
To: John Cole
Cc: 'gdal-dev at lists.maptools.org'
Subject: Re: [Gdal-dev] OGR VRT performance through ODBC...

John Cole wrote:
> Hello,
>   I have a OGR VRT layer defined through ODBC to a MsSqlSpatial database:
> 
> <OGRVRTDataSource>
>     <OGRVRTLayer name='HUDPLS'>
> 		<SrcDataSource>ODBC:mapserver at HUDPLS</SrcDataSource>
> 		<SrcSQL>SELECT t.oid, t.casenumber, t.casestepnu, t.the_geom
> FROM ST.FilterQuery('properties', 'the_geom', ST.MakeEnvelope(%BBOX%, -1))
> AS q
> INNER JOIN properties AS t ON q.oid = t.oid
> where t.casestepnu='06' and t.inaca=0</SrcSQL>
> 		<GeometryType>wkbPoint</GeometryType>
> 		<GeometryField encoding='WKB' field='the_geom'/>
>     </OGRVRTLayer>
> </OGRVRTDataSource>
> 
> This works, but performance is a little disappointing.  MapServer renders
> this layer in ~3.5 seconds, while a postgis layer with the same data is
> rendered in ~0.35 seconds.  Running the query in SQL Server Management
> Studio has all 23 rows returned in 0.00 seconds, so I'm fairly sure that
the
> issue is not MsSqlSpatial.  There are 260K points in the table, but only
23
> are returned in my test query.
> 
> Is there anything I can do to configure either the ODBC driver (SQL Native
> Driver) or the VRT layer itself to improve performance?

John,

Does it take 2-3 seconds for ogrinfo to run against the above .vrt file,
dumping the result features?  I'm wondering if the issue relates to
the simplest of OGR feature reading or if it might be something that
mapserver is doing (like the two pass read done for query rather than
simple draw operations).

Best regards,
-- 
---------------------------------------+------------------------------------
--
I set the clouds in motion - turn up   | Frank Warmerdam,
warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | President OSGeo, http://osgeo.org

-- 
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.12/724 - Release Date: 3/16/2007
12:12 PM
 

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.12/724 - Release Date: 3/16/2007
12:12 PM
 
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.