[Mapserver-dev] Any experience with SQL Relay?

[Sean Gillies]

Cool, thanks for the reference, Paul.

Sean

On Jun 22, 2004, at 12:20 PM, Paul Ramsey wrote:

> Sean,
>
> You might want to check out 'pgpool' as a pooling alternative. It is 
> actively maintained and is pgsql native. 
> (http://www2b.biglobe.ne.jp/~caco/pgpool/index-e.html)
>
> Paul
>
> Sean Gillies wrote:
>
>> On Jun 18, 2004, at 10:21 AM, Frank Warmerdam wrote:
>>> Sean Gillies wrote:
>>>
>>>> I'm looking into whether SQL Relay
>>>>    http://sqlrelay.sourceforge.net/
>>>> would be useful for improving MapServer connections to PostGIS.
>>>> Anyone have any experience with this software?  Any reason
>>>> why I couldn't implement a PostGIS driver that would connect
>>>> to an external SQL Relay connection pool?
>>>
>>>
>>> Sean,
>>>
>>> My understanding is that the connection cost for PostGIS is 
>>> negligable.
>>> However, it might be of great interest to do this for Oracle and ODBC
>>> connections.
>>>
>>> Best regards,
>> Frank, for us it is as much about DB replication and fine control
>> over the number of connections, but our analysis also says that the
>> negligible cost is starting to add up in our app.
>> I've only started to look into it.  If I decide to start work I'll
>> CC you on the bugzilla issue and we can see about Oracle and ODBC.
>> cheers,
>> Sean
>> -- 
>> Sean Gillies
>> sgillies at frii dot com
>> http://users.frii.com/sgillies
>> _______________________________________________
>> Mapserver-dev mailing list
>> Mapserver-dev at lists.gis.umn.edu
>> http://lists.gis.umn.edu/mailman/listinfo/mapserver-dev
>
>
> -- 
>       __
>      /
>      | Paul Ramsey
>      | Refractions Research
>      | Email: pramsey at refractions.net
>      | Phone: (250) 885-0632
>      \_
> _______________________________________________
> Mapserver-dev mailing list
> Mapserver-dev at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-dev
>