ThinkGeo.com    |     Documentation    |     Premium Support

Mssql2008layer on Google Map redraw

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

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

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

Hi Wilhelm,

Very glad to hear it work for you.

Any questions please let us know.

Thanks,
Peter