> Or store the recordset in an application scope variable. If you're using
CF5
> then you could use query or queries to save on DB hits.
>
Sick puppy......  ;o) Don't be using Query of Query unless the data is
coming from seperate datasources!  Right your queries efficiently and
properly in the first place and cache them appropriately!

Picking up a cached query is no slower than picking up a query from an
application variable.

Stephen


______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to