ThinkGeo.com    |     Documentation    |     Premium Support

Mssql2008layer on Google Map redraw

#1

Good day i am currently using Thinkgeo Web Edition. In my program i make use of a mssql2008 layer on top of a google map baselayer. The map works very well but when i zoom in /out of the map the redraw of the sql spatial data is quite slow compared to the baselayer and this Hugely compromises the interactivity of the map.

How can i work around this?
Any help would be greatly appreciated

Best Regards

#2

Hi Wilhelm,

We have an internal cache mechanism for GoogleMapsLayer, the tile are loaded from the local cache which have been cached.

For this issue, please try the following steps:

  1. Please call MsSql2008FeatureLayer.BuildIndex, which should be helpful to improver the sqatial query speed on database side.

  2. I think we can use the TileCache system. Please see the follwing:

    FileBitmapTileCache bitmapTileCache = new FileBitmapTileCache(); 
bitmapTileCache.CacheDirectory = "directory";
bitmapTileCache.CacheId = "World02CachedTiles";
staticLayerOverlay.TileCache = bitmapTileCache;

    More information please refer to http://community.thinkgeo.com/t/introducing-the-tile-cache-generator-for-map-suite/7739

If something misunderstood here. Please provide more information.
Thanks,
Emil

#3

Thanks i have included the Buildindex into my code and it seems to make a difference. Will investigate google tiles soon Regards

#4

Hi Wilhelm,

Very glad to hear it work for you.

Any questions please let us know.

Thanks,
Peter