Well, that's the problem. We don't want to buy a bigger DB server, we would like to buy more application servers and load balance them, so we can offload some of the processer usage on the app servers.
I thought we could use Java or C++ for the db transactions instead of ColdFusion and stored procs if we could get some performance increase out of it. CB >On Wednesday 10 Nov 2004 13:32 pm, Chris Bestall wrote: >> What is the best way to add performance to an application ... >> ... The database server is under too much >> of a load > >I think you've answered you own question - buy a bigger DB server. >Stored procs are almost always more efficent than select statements, esp. for >operations on large datasets. >You might look at caching more information in the application or session >scopes to relieve a little of the load, but that's only going to be a stop >gap - I assume the number of users/items in the system is only going to get >bigger :-) > >-- >Tom Chiverton >Advanced ColdFusion Programmer >Tel: +44 (0)1749 834900 >email: [EMAIL PROTECTED] >BlueFinger Limited >Underwood Business Park >Wookey Hole Road, WELLS. BA5 1AF >Tel: +44 (0)1749 834900 >Fax: +44 (0)1749 834XXX >web: www.bluefinger.com >Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, >BRISTOL. BS1 6EG >*** This E-mail contains confidential information for the addressee only. If >you are not the intended recipient, >please notify us immediately. You should not use, disclose, distribute or copy >this communication if received >in error. No binding contract will result from this e-mail until such time as >a written document is signed on >behalf of the company. BlueFinger Limited cannot accept responsibility for the >completeness or accuracy of >this message as it has been transmitted over public networks.*** ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:183875 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
