[ka-Map-users] Tuning Apache and PHP on Windows 2000

[percy]

Jeff, you can also precache all tiles once you get things stable cartographically. This really speeds things up. It goes thru and builds every tile for every group for every scale.

You can either run precache2.php from the command line, or use the modifications that we posted a while back to make it run from a browser.

Look at the Wiki for more info.
Percy

Date: Wed, 04 Oct 2006 11:53:13 -0400
From: Stephen Woodbridge <woodbri at swoodbridge.com>
Subject: Re: [ka-Map-users] Tuning Apache and PHP on Windows 2000?
To: Jeff Dege <jdege at korterra.com>
Cc: ka-map-users at lists.maptools.org
Message-ID: <4523D8E9.3030001 at swoodbridge.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Jeff you might try creating just a metatile sized image in mapserver and 
compare that to your performance generating tiles. tile.php does 
basically two things:

1) it generates the metatile
2) it chops the metatile in m x n tiles and writes these to the ka-map 
cache using php_gd module.

You might modify tile.php to compute times to do each of these steps and 
have it write a message to stderr so it gets routed to the apache 
error.log and then you can get some idea of what part of this is slow.

You might be able to get more fine grained and look at the time cost to 
draw each layer which would indicate if you have a mapfile/data 
performance issue.

Do ALL *.shp files have a *.qix file associated to them? This can have a 
MAJOR impact on performance.

-Steve

Jeff Dege wrote:

> > I've been watching things in Performance Monitor, and we're not paging,
> > and we're not coming close to the limits of available CPU, memory, or
> > disk throughput.
> > 
> > Which is why I was wondering if we might be bouncing up against
> > configurable limits in Apache or PHP.
> > 
> > The delay seems to be in generating tiles.  If I clear the browser's
> > buffer, the tiles show up quite snappily.
> > 
>   
>> >> -----Original Message-----
>> >> From: Stephen Woodbridge [mailto:woodbri at swoodbridge.com] 
>> >> Sent: Tuesday, October 03, 2006 6:14 PM
>> >> To: Jeff Dege
>> >> Cc: ka-map-users at lists.maptools.org
>> >> Subject: Re: [ka-Map-users] Tuning Apache and PHP on Windows 2000?
>> >>
>> >> Jeff Dege wrote:
>>     
>>> >>> We're running KA-Map on Windows 2000.  And it's working 
>>>       
>> >> fine, except for
>>     
>>> >>> performance.
>>> >>>
>>> >>> Tile generation is taking way too long.  30-40 seconds, sometimes.
>>> >>>
>>> >>> I don't think we can do much more with the mapfile - Mapserver draws
>>> >>> maps much more quickly.
>>> >>>
>>> >>> I was wondering if there were any configuration options in 
>>>       
>> >> Apache or PHP
>>     
>>> >>> that might be bottlenecking things.
>>> >>>
>>> >>> Anyone have any ideas?
>>>       
>> >> Well, you need to remember that ka-map draws a meta tile which is 
>> >> typically 5x5 regular tiles so it need 25 times the image memory 
>> >> required to draw a single tile. This may cause your system to page to 
>> >> disk which would REALLY slow things down.
>> >>
>> >> You can try making your meta tiles smaller, or add more memory. Other 
>> >> than the larger memory requirements and the effort to chop 
>> >> and store the 
>> >> individual tile, it is just mapserver running.
>> >>
>> >> You cant to make sure you do NOT have the force option 
>> >> configured ot it 
>> >> will regenerate the tiles on EVERY request which is not what you want.
>> >>
>> >> Are things fast, if you pan across an area that you have 
>> >> already panned 
>> >> over in the past, ie are you pulling cached tiles or are you 
>> >> generating 
>> >> the tile again?
>> >>
>> >> -Steve W.