JavaScript Dropdown Menu


JavaScript Dropdown Menu Home Company Team Careers Bring Deliver Package Express Link 1 Link 2 Link 3 Link 4 Contact
Welcome Guest! Sign In Link Market

Coldfusion Query Rules
Posted By Justin Small on Sep 20, 2011 :: 0 Comments :: Back To All Articles

<p> Coldfusion isn't a database management interface. There's always been the saying, let the database do database things, let Coldfusion do Coldfusion things.... so here are a few rules in helping to keep Coldfusion as "untaxed" as possible with regards to queries.</p>
<ul>
    <li><span class="Apple-style-span" style="font-family: 'Trebuchet MS', verdana, arial, sans-serif; font-size: 13px; ">Don't ever retrieve data you don't need.<br />
    </span></li>
    <li>Don't ever retrieve too much data, only to filter the results within ColdFusion (via querying a query, or excluding data while looping).</li>
    <li>Don't ever retrieve data if that data is only going to be used to drive additional queries. If you have a query, and then are using the results (perhaps in a <cfloop>, or via a ValueList()) in subsequent queries, then you need to find a way to consolidate those queries and do the work on the DBMS. And yes, that may mean writing JOINs or using stored procedures.</li>
    <li>Don't ever perform calculations and aggregations within ColdFusion, unless the data being used is already retrieved for some other purpose. Yes, the SQL aggregate functions (and having to use GROUP BY and figuring out how to make that work while using WHERE or JOINs) can be a little tricky. But do it anyway.</li>
    <li>Don't ever underestimate the important of caching query results. If you use the data frequently, and it is not changing as frequently as it is used, then cache it!</li>
</ul>
<p>Thanks Ben Forta for this invaluable information. There is more to go along with this article on his site, <a href="http://forta.com/blog/index.cfm/2006/12/1/ColdFusion-Is-Not-A-DBMS">http://forta.com/blog/index.cfm/2006/12/1/ColdFusion-Is-Not-A-DBMS</a>.</p>
<p> </p>

Comments
No Comments

Post A Comment
Name:
Email:
Comments:
Security Code:
Enter Security Code:

.: How to Execute or Run a .bin f :.

.: Coldfusion Next Previous :.

.: Common Mime Types :.

.: Copy files to another computer :.

.: Online Cyber Safety - ISIS Wan :.

.: Start Coldfusion 11 from Ubunt :.

.: How to Use Multiple Monitors a :.

.: How To Install Flash Player Pl :.

.: Creative Web Solutions Feature :.

.: What Coldfusion isnt :.

.: Coldfusion Query Rules :.

.: Using CFLOOP To Dynamically Cr :.

Previous Posts