Last week when I looked at databases pools I got a few suggestions re master/slaves databases. In this configuration you set up a single database (called the master) and have it replicate to one or more other databases (called the slaves).
Using ColdFusion it's fairly straight forward to make web pages appear in more than one language.
First off you need to detect what language you want the page to be in, next you load the strings you want to display from a resource file and lastly display the page in the required language.
You've tuned your databases queries, added all of the indexes you can think of and cached all of the queries you can but your database still isn't giving you the performance you need.
So it's time to split up your database into several databases and move each of these new databases off onto separate database servers. Or perhaps a RAID database is the solution to your performance issues.
Singletons are perhaps one of the most simple Design Patterns. For those who don't know sigletons are a class that can only have one instance. They can be thought of as a glorified global variable - but are a lot more useful.
Most ColdFusion classes, or rather instances of CF components, can be turned in a singleton by placing the following code in your Application.cfm:
<cfset application.<instance name> = createobject("component",<path to component>)>
or OnApplicationStart method of your Application.cfc: