WKT in SQL Server

[Frank Warmerdam]

Crispin and Naomi wrote:
> Hi all,
> I mailed some of this before, but trying again a bit clearer I hope...
>  
> I have SQL Server tables containing WKT in a "memo" field, plus X/Y 
> fields plus MINX, MINY, MAXX, MAXY fields defining the bounding boxes 
> for each record.
>  
> I'm dishing this up as a WMS just fine through MapServer , but one 
> problem is that it drags the whole table out of the database for each 
> request. I have bounding box fields in the database and I was hoping it 
> would use these to pull only the features in the view extent. More detail:
...
> Can I do better?   (and PS no I cannot just move it all into PostGIS, 
> though I realise that might be better until SQL 2008 is released with 
> spatial support !)

Crispin,

The ODBC driver should support using spatial extents if available.  I'm not
sure why isn't working for you.  Would you be willing to try and copy the
table in question, or at least a few records from it, to an .mdb file and
try the same request?  If that has the same problem it would be easy to
report it as a bug report against GDAL/OGR and for me or Mateusz to
track it down.

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