FDO SQL Server queries whole tables for SRID - reduce to top 1

[gluckett]

I used a Database Sniffer to look at the SQL that AutoCAD Map 3D pulls from SQL Server when first connecting in FDO.

For example, for every table in my GIS, it runs:

 select   [GEOMETRY_COLUMN].STSrid as srid from "MYTABLE"

So if I have 50 tables with 1 million records, it performs a 50 million record query to get the SRIDs (Coordinate System).

I suggest it changes the query to:

select  top 1 [GEOMETRY_COLUMN].STSrid as srid from "MYTABLE"

for each table - that way it only queries 50 records rather than 50 million.

Boy would SQL Connections in FDO be faster eh?