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/[EMAIL PROTECTED],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/[EMAIL PROTECTED] [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/[EMAIL PROTECTED],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/[EMAIL PROTECTED]) -> 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/[EMAIL PROTECTED] [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/[EMAIL PROTECTED],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/[EMAIL PROTECTED] [Wed Nov 14 09:34:15 2007].27958 msOracleSpatialLayerClose was called. Layer name: On-Air. Layer connection: username/[EMAIL PROTECTED] [Wed Nov 14 09:34:15 2007].29464 msConnPoolClose(username/[EMAIL PROTECTED],87b7130) ---- Timothy J Nolte - [EMAIL PROTECTED] 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:[EMAIL PROTECTED] > Sent: Wednesday, November 14, 2007 9:27 AM > To: Nolte, Tim > Cc: [EMAIL PROTECTED] > 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 - [EMAIL PROTECTED] > > 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 > > [EMAIL PROTECTED] > > http://lists.maptools.org/mailman/listinfo/chameleon > > > > -- > Julien-Samuel Lacroix > Mapgears > http://www.mapgears.com/ > >
