[mapserver-users] SDE performance

[Steve Lime]

I think folks will take it seriously, but the timing may a bit bad with
folks
rushing to polish of work in 3.7. At a minimum this should be logged
in
Bugzilla so it doesn't get lost. If someone would like to work on a fix

that doesn't involve global variables, but rather a connection pool
that
becomes part of the main mapObj then I (as the SDE guy) would be
happy to work to implement it. I don't think it's too hard, just a
bunch
of bookeeping since you might leverage multiple SDE/Oracle or PostGIS
connections in a single run.

Steve

Stephen Lime
Data & Applications Manager

Minnesota DNR
500 Lafayette Road
St. Paul, MN 55155
651-297-2937

>>> "C F" <gis_consultant at hotmail.com> 11/20/02 12:24PM >>>
Regarding MapServer creating a NEW db connection for each db layer....
is 
anyone else taking this seriously?  I thought this would be just the 
beginning of the discussion but there doesn't seem to be too much
interest 
in this besides us few.  This seems like a pretty unnecessary
performance 
constraint.  I would think that it would be a fairly easy fix, but it's
not 
my place to be making those assumptions... But I just thought I'd bring
it 
up again in case everyone forgot :)


>From: Jan Hartmann <jhart at frw.uva.nl>
>To: mapserver-users at lists.gis.umn.edu 
>Subject: Re: [mapserver-users] SDE performance
>Date: Wed, 13 Nov 2002 11:57:40 +0100
>
>My impression is that this would not be very hard to implement: just a

>global array with pointers to every CONNECTION opened in all LAYERS.
The 
>applications itself (PostGIS, SDE, Oracle) could test for already open

>connections. The only thing MapServer itself would have to do is
closing 
>all connections at the end.
>This would certainly be of great help for Oracle and SDE users; large

>connection overheads have been mentioned regularly on this list. Even
for 
>PostGIS there are advantages; think about reusing complex queries with

>spatial operators and TMP tables. IMHO certainly worth looking into!
>
>Jan Hartmann
>
>
>Paul Ramsey wrote:
>>One possibility would be to abstract the connection making process a
bit, 
>>so that a 'getConnection' function first checks a hash to see if
there is 
>>already a connection with parameters which match the requested
connection. 
>>It would probably have to reside on the mapObj though...
>>
>>P.
>>
>
>Jan Hartmann
>Department of Geography
>University of Amsterdam


_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail