[mapserver-users] SDE performance

[Jan Hartmann]

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