multiple connections through same user
517513Jun 28 2006 — edited Jun 29 2006We have a web app with an n-tier backend. We have found that if we have around 7 server apps on a single box but have found when we push past that it starts degrading performance severely.
All of our back end apps connect to the database as the same user and I'm wondering if we are bottle necking either on the database server or the back end server through the driver. The apps are written in VB6.0 and PowerBuilder7.x.
Should we put in an additional network card in the box and point another driver through it? I don't even know if it can be done but there has to be a setting or change I can make to help it out.
-Herb