[fdo-users] Can't select features using SQL Server data connection

[Hans Milling]

A few things to try:

1. Create a spatial index on your geometry column. This is very important or
SQL server has to go through all rows/geometry to find what is within the
current map window. This will make querying data very slow.
2. If you have any filters or rules, be sure to create index on the columns
used in these filters or rules. This can help a lot too with performance.
3. If you have thousands of points, line or polygons in a layer, change the
scale range (wich zoom level a layer is visible). Like an address layer
where you have house numbers. It makes no sens to display this when zoomed
all the way out. Change the scale range from infinity to like 1:1000 to make
the address first display when you zoom in. Optimising the scale ranges can
make your map perform a lot faster.

Best regards
  Hans Milling...



--
Sent from: http://osgeo-org.1560.x6.nabble.com/FDO-Users-f3898664.html