Dear Andrea
Andrea Aime wrote:
Well, the machine is not recent and the shapefile are relatively big,
you definitely won't get instant display trying to put 100MB of
shapefile data on screen.
There are a number of things that can be done to speed up things:
- use the most recent JDK you can find
My Installed JDK is : jdk1.6.0_10
- on that hardware there's no change the VM will switch to server
mode by itself, you'll have to tweak the JVM settings manually,
see: http://geoserver.org/display/GEOSDOC/2.6+GeoServer+in+Production+Environment
Woooppss .... so many variables to set on JVM section ... I don't know how to do it, since I just Install XAMPP, JDK, and Tomcat
- download and install the native portions of JAI and JAI Image I/O
Done
I Think I "feel" some small performance raise
from jai.dev.java.net and jai-imageio.dev.java.net
- try not to display all that data in a single shot but use
SLD scale dependency rules to display only parts of your data at
a time
Hmm .. I need to know more about SLD first
- if your map is tiled, use a tile cache (e.g. GeoWebCache) to
cache the tiles and forget about speed issues altogether.
Of course this assumes your data is not changing fast
Onfortunately .. the shapefiles is gathered from converting single *.mp file.
I read about MySQL data store.
Will it help ?
My wishes about this MySQL dataStore solution is :
- The amount of loaded data is "on demand"
- The map will show label of each object. With Shapefile, looks like the label disapear
I use ogr2ogr to inject my Shapefile to MySql.
Looks like generated database/table structure is diferent per http://geoserver.org/display/GEOSDOC/MySQL+DataStore
my Table structure (export from PhPMyAdmin) :
CREATE TABLE IF NOT EXISTS `navnet_line` (
`OGR_FID` int(11) NOT NULL auto_increment,
`SHAPE` geometry NOT NULL,
`type` decimal(5,0) default NULL,
`label` varchar(80) default NULL,
`descr` varchar(80) default NULL,
`label3` varchar(80) default NULL,
`city` varchar(80) default NULL,
`region` varchar(80) default NULL,
`country` varchar(80) default NULL,
`zip` varchar(80) default NULL,
`oneway` decimal(1,0) default NULL,
`toll` decimal(1,0) default NULL,
`speed` decimal(2,0) default NULL,
`roadclass` decimal(2,0) default NULL,
`roadid` decimal(9,0) default NULL,
`level` decimal(5,0) default NULL,
`endlevel` decimal(5,0) default NULL,
UNIQUE KEY `OGR_FID` (`OGR_FID`),
SPATIAL KEY `SHAPE` (`SHAPE`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=241979 ;
Sincerely
-bino-