I don't know if this will help, but may spur some ideas. Currently I use Bing Maps to overlay my GIS stuff on.... (not my preference but the client's). I have my GIS data in SQL server. What I do for displaying large numbers of data points for example "Street Lights" is to query the users exent and do an intersect spatially against the GIS data only returning those street lights in the users current view.
My SQL procedure for sending back only data found in the extent sent to it as parameters ul/br lat and long (Upper Left/ Lower Right)
USE [GeoTest]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[usp_ColorLightLC]
@ulLat nvarchar(10),
@ulLong nvarchar(10),
@brLat nvarchar(10),
@brLong nvarchar(10)
AS
BEGIN
SET NOCOUNT ON;
DECLARE @SearchRectangleString VARCHAR(MAX);
SET @SearchRectangleString = 'POLYGON((' + @ulLong + ' ' + @ulLat + ',' + @ulLong + ' ' + @brLat + ',' + @brLong + ' ' + @brLat + ',' + @brLong + ' ' + @ulLat + ',' + @ulLong + ' ' + @ulLat + '))';
Declare @G geography;
Declare @SearchArea geometry;
SET @G = geography::STPolyFromText(@SearchRectangleString, 4326);
SET @SearchArea = geometry::STGeomFromWKB((Select @G.STAsBinary()),4326);
Select
Shape.STGeometryType() as GeometryType,
Shape.STAsText() as WKT,
'Light' as Title,
'LoadCenterID: ' + cast(LoadCenterID as nvarchar) as Description,
LoadCenterID,
1 as FT
from
MDXLIGHTS
where
Shape.STIntersects(@SearchArea) = 1 and LoadCenterID <> 998
union all
select
Shape.STGeometryType() as GeometryType,
Shape.STAsText() as WKT,
'LoadCenter' as Title,
'LoadCenterID: ' + cast(LoadCenterID as nvarchar) as Description,
LoadCenterID,
0 as Feat
from LOADCENTERS
where
Shape.STIntersects(@SearchArea) = 1
Order by LoadCenterID ASC, FT DESC
END
