Tab, Shp, Shptree, PostGIS performance
erki.saluveer at REGIO.EE
Thu Nov 3 05:22:27 EST 2005
I've been using Minnesota Mapserver for a while with a big success. Though I
haven't understood completely which file formats to read fits best for
Biggest mystery is shape file. It should be the fastest file format to read,
but it's been the slowest in all my tests.
Like one test I made with Mapinfo TAB, ESRI shape, PostGIS database table
and shptree file.
I had at first one MapInfo dataset (33 Mb). To get shape file I translated
it with MapInfo's Universal Translator. From shape file I made qix file with
shptree in depth 8 and using shp2pgsql I created database entry file (I also
indexed postgis table)
Then I put together 4 different map files to read these. Test was made with
single and concurrent queries (500 queries for each map file).
The results are as follows:
Time per request
Time per concurrent request
SHP with qix
* Times are in milliseconds
Why is shape so slow?!? I appreciate any help to find answer to this
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the mapserver-users