🚀 go-pugleaf

In article 16015@midway.uchicago.edu, colin@agincourt.bsd.uchicago.edu (& Garrett) writes:
>Speaking of having to have extra connections, does anybody know why DBKit  
>needs to establish two connections for each DBDatabase?
>With DBModeler unable to support cross-database joins and the need to  
>augment DBKit code with my own dblibrary stuff, my two-database app ends  
>up needing five connections per user, which is just gross.

This is one of my major gripes with DBKit. The number of connections to a Sybase server is 
a limited resource (max. 250). This may seem like a lot, but for more complex database apps
or systems with lots of users these connections can be maxed out very easily. Any application
that needs more connections than the server can support is going to have problems. I haven't
proven that DBKit has these problems, but I think it will. My advice is to try as hard as you can
to get by with one connection. The benefits of using more than one connection per server in an
app are not that great and the problems that may be caused by using more than one are not trivial
to solve.

---
Kevin Hegg                       Internet: e3ukjh@fnma.com
Fannie Mae                       Phone: (202) 752-7813