Also, as a side note. Its not always more efficient to use a query of a query, only severe load testing can determine that.
Since most db's can cache results internally, often the db is way faster-- especially under heavy load on the CFML server. Modern multi core servers are very efficient at distributing loads from individual servers to the different cores, and usually CPU is still available even though the CFML server is under heavy load. They do thread themselves to a point, but there are limitations to how efficient threading is within the jvm. So if your initial query does what you need, run a few query's and don't worry about the efficiency's too much unless you discover it is really an issue-- If it is, then try to optimize it with application scope caching. -- /Kevin Pepperman -- Open BlueDragon Public Mailing List http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon mailing list - http://groups.google.com/group/openbd?hl=en !! save a network - please trim replies before posting !!
