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.
What makes you think that? Where IS the performance going to? Search for
the objects, reading them from disk, of rendering the objects? If you
don't know then you are probably trying to optimize the wrong thing.
Many of us have been working with mapserver for years and we have looked
into these questions and I can tell you (as Attila did) that shapefile
are the fastest. Do all you shapefiles have spatial indexes *.qix files
associated with them? Start there.
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.
--- Attila Csipa <[EMAIL PROTECTED]> escribió:
On Friday 03 March 2006 16:38, Ker Nulov wrote:
draw layers using MySQL access? I need it to
improove
speed. My application uses mapscript with php.
Shapefiles are likely the fastest storage for
small/generic data, moving to
mysql (or any other database for that matter) will
probably not speed up
things on itself unless you're really using some
DBMS specific feature.
___________________________________________________________
Do You Yahoo!?
La mejor conexión a Internet y <b >2GB</b> extra a tu correo por $100 al mes. http://net.yahoo.com.mx
