shapes to MySQL

[Puneet Kishor]

Stephen Woodbridge wrote:
> Ker Nulov wrote:
>> Ohh, well, my shapefile 78 MB and it has 140,000
>> polygons. displaying 1km of zoom taks 1 sec, this is
>> too much for our application. I bet a query in MySQL
>> will be faster.
> 

Ker,

The problem with your assertion is that someone might take you up on
your bet ;-)

> To answer your question, NO, you can not put your shapefiles in MySQL and render then via mapserver. You can put them in postGIS, but they will be slower than shapefiles.
> 
> -Steve W. 

As Steve W and Attila suggested, just stuffing your data into a database
is not going to make the process faster. Actually, you _can_ put shape
data into MySQL (as Attila can testify), but PostGIS is the more
well-supported way, and well indexed shapefiles really are the fastest.

You might want to benchmark your code.

You might want to create new scaled and tiled versions of your data, so
only relevant portions are munged by MapServer.

You might want to benchmark your code (I said that already). Really.
Only that will tell you what is it that is actually slowing things down.

--
Puneet Kishor