I'm going to to quote Ben Forta (et al) here: "ColdFusion is not a database server"
If you intend to do frequent, perhaps complex QoQ on the query in memory, you may be better off simply going to the DB. Multiple calls to the DB in a page will reuse the same DB connection and for most purposes CF will reuse the same connection again on subsequent requests from all of your pages. On 11/12/06, Paul Boyd <[EMAIL PROTECTED]> wrote: > As long as my application is running, I have the recordsets available in > memory, and i can use QoQ to do all the drill down data manipulation. > In other words, I would only have one database connection , during the > application startup, if I understood correctly. -- CFAJAX docs and other useful articles: http://www.bifrost.com.au/blog/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260067 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
