If it's a processor load question, the only solution is to use a different processor, and that means your app server. A different connection mechanism isn't going to help.
In theory, if you remove all your stored procs and only use simple queries (doing all the logic on your app server), then you'd reduce load on the DB server. I don't know how much, but probably a noticable amount. You'd definitely increase load on the app servers though, and by a large margin. I don't know what your hardware looks like, but is there a reason you can't buy a new DB server and move hte existing DB server into an app server role? When we put together an app cluster last year, that's what we designed it to do, and it worked well. Started with a pair of dual-proc DB servers and a pair of slightly less beefy app servers. Load increased, we bought a pair of beefier quad-proc DB server with a bunch more ram and moved the old DB servers into the app cluster. cheers, barneyb On Wed, 10 Nov 2004 20:25:28 -0400, Chris Bestall <[EMAIL PROTECTED]> wrote: > Yes, unfortunately, I don't have a lot of details as of yet. > > What I do know is that we want to keep our one DB server(expensive) and > slowly add more app servers(inexpensive) as needed to keep the burden on the > DB server low. App servers running MX6.1 > > I was initially looking at ways, Java or otherwise, to replace what the > stored procs are currently doing and which would be the best. Or at least > the right direction so I can start learning/researching it. > > CB > > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/blog/ I currently have 0 GMail invites for the taking ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183938 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
