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 > Chris Bestall wrote: > > What is the best way to add performance to an application that is > currently utilizing a ColdFusion application server (CF5 -soon to go > to MX) and a database server (SQL Server 2000). The database server > is under too much of a load currently as all transactions are stored > procedures. > > There can be many reasons why your database is under too much of > a load. It can be caused by anything from underpowered hardware > to unoptimized queries. The more detail you provide, the more we > can help. > > Jochem > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:183936 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
