[Chameleon] Chameleon & TileCache...(MapServer Performance)
Nolte, Tim
Tim.Nolte at ipcswirelessinc.com
Wed Nov 14 09:50:41 EST 2007
Here is quick test I ran on the performance of my current setup. If
anyone can see some things I need to do I'd appreciate it. A couple
things that we're kicking around is breaking the layers (Outdoor
Rural/In-Vehicle Rural Hwy/In-Building Suburban/In-Building
Urban/In-Building Dense Urban) down to county level sizes, create a
tileindex of groups of counties, then create a tileindex referencing the
county group tileindex. I really don't think this would improve
performance unless the common zoom/extent was at a county level. The
other thought is loading all of these shapefiles into the Oracle
database as spatial data. I've gotten a request from the higher-ups to
increase the performance of our MapServer. The server we're running on
is a 2.8GHz XEON w/ 3GB of RAM. Thinking that maybe an increase in RAM
might help us out too. At this point we're pretty invested in the
Chameleon framework so a move to another application framework is not
really an option. Thanks.
shp2img -m default.map -o ../mapserver/default.png -e -86.393 42.251
-84.658 43.465 -all_debug 2
[Wed Nov 14 09:34:06 2007].202794 msDrawMap(): Layer 0 (World
Countries), 0.132s
[Wed Nov 14 09:34:06 2007].236996 msDrawMap(): Layer 1 (Sea Labels),
0.033s
[Wed Nov 14 09:34:06 2007].278533 msDrawMap(): Layer 2 (Ocean Labels),
0.041s
[Wed Nov 14 09:34:06 2007].328952 msDrawMap(): Layer 3 (US Land Small
Scale), 0.050s
[Wed Nov 14 09:34:06 2007].386358 msDrawMap(): Layer 4 (US Urban Areas
Small Scale), 0.057s
[Wed Nov 14 09:34:06 2007].428937 msDrawMap(): Layer 6 (US Land Small
Scale - outline), 0.042s
[Wed Nov 14 09:34:06 2007].450979 msDrawMap(): Layer 9 (US Counties),
0.022s
[Wed Nov 14 09:34:08 2007].157881 msDrawMap(): Layer 14 (Outdoor Rural),
1.707s
[Wed Nov 14 09:34:09 2007].777791 msDrawMap(): Layer 15 (In-Vehicle
Rural Hwy), 1.620s
[Wed Nov 14 09:34:11 2007].373600 msDrawMap(): Layer 16 (In-Building
Suburban), 1.596s
[Wed Nov 14 09:34:12 2007].446320 msDrawMap(): Layer 17 (In-Building
Urban), 1.073s
[Wed Nov 14 09:34:13 2007].29197 msDrawMap(): Layer 18 (In-Building
Dense Urban), 0.583s
[Wed Nov 14 09:34:13 2007].328139 msDrawMap(): Layer 20 (US Water Bodies
- Small Scale), 0.299s
[Wed Nov 14 09:34:13 2007].346469 msDrawMap(): Layer 23 (US Large Scale
State Borders), 0.018s
[Wed Nov 14 09:34:13 2007].364500 msDrawMap(): Layer 27 (US Ferries),
0.018s
[Wed Nov 14 09:34:13 2007].419243 msDrawMap(): Layer 29 (US Small Scale
Secondary Highways and Major Roads), 0.055s
[Wed Nov 14 09:34:13 2007].459989 msDrawMap(): Layer 31 (US Small Scale
Primary Highways), 0.041s
[Wed Nov 14 09:34:13 2007].503106 msDrawMap(): Layer 33 (US Small Scale
Controlled Access Highways), 0.043s
[Wed Nov 14 09:34:13 2007].538011 msDrawMap(): Layer 35 (US Small Scale
Highway Shields), 0.035s
[Wed Nov 14 09:34:13 2007].564523 msDrawMap(): Layer 37 (US Populated
Places), 0.026s
[Wed Nov 14 09:34:13 2007].570828 msOracleSpatialLayerOpen called with:
geom FROM (SELECT st.bts_nbr, sgt.geom FROM site_tab st, site_geom_tab
sgt WHERE st.site_id = sgt.site_id AND st.site_status_id = 3) USING SRID
8307
[Wed Nov 14 09:34:13 2007].783949 msOracleSpatialLayerOpen. Shared
connection not available. Creating one.
[Wed Nov 14 09:34:13 2007].784034 msConnPoolRegister(In
Construction,username/password at SID,87b7130)
[Wed Nov 14 09:34:13 2007].909150 msOracleSpatialLayerFreeItemInfo was
called.
[Wed Nov 14 09:34:13 2007].909246 msOracleSpatialLayerInitItemInfo was
called.
[Wed Nov 14 09:34:13 2007].909279 msOracleSpatialLayerWhichShapes was
called.
[Wed Nov 14 09:34:13 2007].909411 msOracleSpatialLayerWhichShapes. Using
this Sql to retrieve the data: SELECT rownum, bts_nbr, geom FROM (SELECT
st.bts_nbr, sgt.geom FROM site_tab st, site_geom_tab sgt WHERE
st.site_id = sgt.site_id AND st.site_status_id = 3) WHERE SDO_FILTER(
geom, MDSYS.SDO_GEOMETRY(2003, 8307,
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-86.39
3,42.2076578,-84.658,43.5083422) ),'querytype=window') = 'TRUE'
[Wed Nov 14 09:34:14 2007].528095 msOracleSpatialLayerFreeItemInfo was
called.
[Wed Nov 14 09:34:14 2007].528179 msOracleSpatialLayerClose was called.
Layer name: In Construction. Layer connection: username/password at SID
[Wed Nov 14 09:34:14 2007].528212 msOracleSpatialLayerClose. Cleaning
layerinfo handlers.
[Wed Nov 14 09:34:14 2007].528339 msOracleSpatialLayerClose. Cleaning
Oracle Cache.
[Wed Nov 14 09:34:14 2007].528510 msOracleSpatialLayerClose. Release the
Oracle Pool.
[Wed Nov 14 09:34:14 2007].528552 msConnPoolRelease(In
Construction,username/password at SID,87b7130)
[Wed Nov 14 09:34:14 2007].539690 msDrawMap(): Layer 46 (In
Construction), 0.975s
[Wed Nov 14 09:34:14 2007].545616 msOracleSpatialLayerOpen called with:
geom FROM (SELECT st.bts_nbr, sgt.geom FROM site_tab st, site_geom_tab
sgt WHERE st.site_id = sgt.site_id AND st.site_status_id IN (4,7)) USING
SRID 8307
[Wed Nov 14 09:34:14 2007].545781
msConnPoolRequest(On-Air,username/password at SID) -> got 87b7130
[Wed Nov 14 09:34:14 2007].558612 msOracleSpatialLayerFreeItemInfo was
called.
[Wed Nov 14 09:34:14 2007].558696 msOracleSpatialLayerInitItemInfo was
called.
[Wed Nov 14 09:34:14 2007].558729 msOracleSpatialLayerWhichShapes was
called.
[Wed Nov 14 09:34:14 2007].558792 msOracleSpatialLayerWhichShapes. Using
this Sql to retrieve the data: SELECT rownum, bts_nbr, geom FROM (SELECT
st.bts_nbr, sgt.geom FROM site_tab st, site_geom_tab sgt WHERE
st.site_id = sgt.site_id AND st.site_status_id IN (4,7)) WHERE
SDO_FILTER( geom, MDSYS.SDO_GEOMETRY(2003, 8307,
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-86.39
3,42.2076578,-84.658,43.5083422) ),'querytype=window') = 'TRUE'
[Wed Nov 14 09:34:14 2007].795099 msOracleSpatialLayerFreeItemInfo was
called.
[Wed Nov 14 09:34:14 2007].795180 msOracleSpatialLayerClose was called.
Layer name: On-Air. Layer connection: username/password at SID
[Wed Nov 14 09:34:14 2007].795215 msOracleSpatialLayerClose. Cleaning
layerinfo handlers.
[Wed Nov 14 09:34:14 2007].795289 msOracleSpatialLayerClose. Cleaning
Oracle Cache.
[Wed Nov 14 09:34:14 2007].795422 msOracleSpatialLayerClose. Release the
Oracle Pool.
[Wed Nov 14 09:34:14 2007].795473
msConnPoolRelease(On-Air,username/password at SID,87b7130)
[Wed Nov 14 09:34:14 2007].806672 msDrawMap(): Layer 47 (On-Air), 0.267s
[Wed Nov 14 09:34:14 2007].884647 msDrawMap(): Drawing Label Cache,
0.078s
[Wed Nov 14 09:34:14 2007].884822 msDrawMap() total time: 8.836s
[Wed Nov 14 09:34:15 2007].27863 msOracleSpatialLayerClose was called.
Layer name: In Construction. Layer connection: username/password at SID
[Wed Nov 14 09:34:15 2007].27958 msOracleSpatialLayerClose was called.
Layer name: On-Air. Layer connection: username/password at SID
[Wed Nov 14 09:34:15 2007].29464
msConnPoolClose(username/password at SID,87b7130)
----
Timothy J Nolte - tnolte at ilpcs.com
Associate Network Planning Engineer
iPCS Wireless, Inc.
4717 Broadmoor Ave, Suite G
Kentwood, MI 49512
Office: 616-656-5163
PCS: 616-706-2438
Fax: 616-554-6484
Web: www.ipcswirelessinc.com
> -----Original Message-----
> From: Julien-Samuel Lacroix [mailto:jlacroix at mapgears.com]
> Sent: Wednesday, November 14, 2007 9:27 AM
> To: Nolte, Tim
> Cc: chameleon at lists.maptools.org
> Subject: Re: [Chameleon] Chameleon & TileCache...
>
> Hi,
>
> Chameleon use the MapServer mapfile as a base configuration file. I
> don't think you can easily use other source for your map
> rendering other
> than that. You may have more luck with more standard method to boost
> rendering time.
>
> First things to check:
> - Remove any projection block in your mapfile. Reprojection
> on the fly
> is really CPU consuming.
> - Make sure you use simple expressions in your classes.
> - Follow the tips for vector and raster data access improvement here:
> http://mapserver.gis.umn.edu/docs/faq/performance
> http://mapserver.gis.umn.edu/docs/howto/raster_data/#preproces
> sing-rasters
>
> Julien
>
> Nolte, Tim wrote:
> > I'm wondering if anyone has experience with using TileCache
> along with
> > Chameleon? Is this even possible? We have a large amount of
> data that we
> > need to try and boost the performance of and wondering if TileCache
> > might be the ticket. Thanks.
> >
> > - Tim
> >
> > ----
> > Timothy J Nolte - tnolte at ilpcs.com
> > Associate Network Planning Engineer
> >
> > iPCS Wireless, Inc.
> > 4717 Broadmoor Ave, Suite G
> > Kentwood, MI 49512
> >
> > Office: 616-656-5163
> > PCS: 616-706-2438
> > Fax: 616-554-6484
> > Web: www.ipcswirelessinc.com
> >
> > _______________________________________________
> > Chameleon mailing list
> > Chameleon at lists.maptools.org
> > http://lists.maptools.org/mailman/listinfo/chameleon
> >
>
> --
> Julien-Samuel Lacroix
> Mapgears
> http://www.mapgears.com/
>
>
More information about the Chameleon
mailing list