[mapserver-users] Mapserver and Microsoft SQL Server 2008

[Fuchs Juan Carlos]

Hi:

Let´s face the challenge!
the big question here is:
it is posible to tile geodata stored in spatial SQL ??

Here goes my first aproach:
divide display accord scale and relevance
say principal roads for the broad view
add data in a relation 20 to one, you just display one small part (one fo
twenty)
if you go to detail scale take 1 to 100.

second aproach.
tile the data using some grid aproach, following the same criteria.
store the tile in your spatial SQL and go for the tile when you address the
DATA statment.

I will tray it by myself, but will be nice to hear some comments fo our
guru´s.

sorry, my english still sucks. :p

JC.

-----Mensaje original-----
De: Chris King [mailto:whereismyshuttle at gmail.com]
Enviado el: Martes, 08 de Abril de 2008 05:34 p.m.
Para: mapserver-users at lists.osgeo.org
Asunto: Re: [mapserver-users] Mapserver and Microsoft SQL Server 2008


I thought I'd share my results of my past few weeks work on resolving my 
problem with the location of the plugin dll I was looking for.

I found the dll in a product at http://www.mapdotnet.com (simply installed 
the demo and copied the dll then uninstalled)

And I have just finished importing all my map data in SQL 2008. I reserved 
the road data for last and noticed a significant decrease in performance as 
I switched between postgre and sql 2008. And average of 1 or 2 seconds 
slower than postgre with a max of about 5 or 6 seconds where lots of detail 
is being displayed on the map.

Anyway, as much as I wana tell Bill his program stinks, we will lose the 
competition if I do ;) so I'm forced to stick with SQL 08 and look for ways 
to improve performance. (Any links will be greatly appreciated)

Cheers
Chris 

_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users