[UMN_MAPSERVER-USERS] RE : [UMN_MAPSERVER-USERS] Win32 binaries with SDE, anyone ?

[Paul Ramsey]

Incidentally, some notes for the list on performance for large data sets:

1 - For very large data sets, nothing will help you more that fast disk
IO.  SCSI disks, spinning as fast as possible, and an IO subsystem can
can handle them, will be the most effective thing you can buy.
2 - After that, lots of memory will allow your operating system to cache
important pieces of data (like indexes!) in memory, again speeding up
your system.
3 - Tuning your database to take advantage of the memory, for
PostgreSQL, check out
http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
effective_cache_size is an oft-overlooked parameter, in addition to the
popular shared_buffers parameter.
4 - CPU speed can help in the final render process, if you are rendering
complex enough maps.
5 - Check your map file for performance bottlenecks. Are there times you
are drawing 10000 high res features when 100 low res features would
provide the same effect? (We are going to commit some patches for 4.4
that put layer timings into the DEBUG logs to make this optimization
process easier.)

Paul

Skweda O'Bomsawin wrote:

> Thanks Paul,
>
> That’s what I thought...  I already made all the tuning in Postgresql and
> I'm satisfied of the results (12 seconds with Mapserver and PostGIS compared
> to about 50 seconds in Mapinfo to display the same dataset), but my clients
> are very demanding...
>
> Skweda O'Bomsawin
>
>
> -----Message d'origine-----
> De : UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU] De la
> part de Paul Ramsey
> Envoyé : 13 octobre 2004 12:40
> À : MAPSERVER-USERS at LISTS.UMN.EDU
> Objet : Re: [UMN_MAPSERVER-USERS] RE : [UMN_MAPSERVER-USERS] Win32 binaries
> with SDE, anyone ?
>
> Skweda,
> FCGI support is already in Mapserver CVS HEAD, Frank Warmerdam did the
> implementation. You will not find that it makes more than 0.1second per
> invocation difference for your PostGIS data, PostGIS has a very low
> connection overhead. FCGI will only help performance for people with
> high loads (lots of incoming requests) not people with large data sets.
>   If you have a huge PostGIS database, tuning at the PostgreSQL and
> operating system level will be more salutary than fcgi.
> Paul
>
> Skweda O'Bomsawin wrote:
>
>
>>You are working on fcgi support in Mapserver?  I'm very interested to test
>>any feature which will improve performance of Mapserver since a have a
>
> road
>
>>Postgis database of about 10Gb to display...
>>
>>Thanks to keep in touch!
>>
>>Skweda O'Bomsawin
>>
>>-----Message d'origine-----
>>De : UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU] De la
>>part de Paul Ramsey
>>Envoyé : 13 octobre 2004 11:32
>>À : MAPSERVER-USERS at LISTS.UMN.EDU
>>Objet : Re: [UMN_MAPSERVER-USERS] Win32 binaries with SDE, anyone ?
>>
>>Lorna,
>>We have some binaries but are currently debugging the new fcgi support
>>and its interaction with the SDE support. If you are patient, you can
>>have copies of our binaries when we have them working.
>>Paul
>>
>>Lorna wrote:
>>
>>
>>
>>>Hi
>>>
>>>I'm hoping someone can offer a copy of their latest win32 Mapserv binary
>>>compiled with SDE support.
>>>
>>>I have SDE 8.3 client software installed, I just dont have the tools to
>>>compile Mapserver under windows. I want to use Mapserver to server spatial
>>>data, instead of ARCIMS but if I cant get MapServer with SDE enabled I'll
>>>have to scrap this idea, which is a real shame !
>>>
>>>Thanks, Lorna
>>
>>
>>---
>>Incoming mail is certified Virus Free.
>>Checked by AVG anti-virus system (http://www.grisoft.com).
>>Version: 6.0.773 / Virus Database: 520 - Release Date: 2004-10-05
>>
>>
>>---
>>Outgoing mail is certified Virus Free.
>>Checked by AVG anti-virus system (http://www.grisoft.com).
>>Version: 6.0.773 / Virus Database: 520 - Release Date: 2004-10-05
>>
>>
>
>
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.773 / Virus Database: 520 - Release Date: 2004-10-05
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.773 / Virus Database: 520 - Release Date: 2004-10-05
>
>