SQL Query Tuning
From a performance and scalability perspective, sql query tuning is one of the
most important elements in Enterprise web development. But it's not enough to
only tune the queries. How they are used within your ColdFusion application is
just as important — sometimes more.
I bring over 15 years of experience
with sql query tuning to your project, primarily working with Microsoft SQL Server,
MySQL and Oracle. Some also with Informix and IBM DB2 databases.
Senior ColdFusion Developer
since 1995
<cfabort> <cfajaximport> <cfajaxproxy> <cfapplet> <cfapplication>
<cfargument> <cfassociate> <cfbreak> <cfcache> <cfcalendar>
<cfcase> <cfcatch> <cfchart> <cfchartdata> <cfchartseries>
<cfcol> <cfcollection> <cfcomponent> <cfcontent> <cfcookie>
<cfdbinfo> <cfdefaultcase> <cfdirectory> <cfdiv> <cfdocument>
<cfdocumentitem> <cfdocumentsection> <cfdump> <cfelse> <cfelseif>
<cferror> <cfexchangecalendar> <cfexchangeconnection> <cfexchangecontact>
<cfexchangefilter> <cfexchangemail> <cfexchangetask> <cfexecute>
<cfexit> <cffeed> <cffile> <cfflush> <cfform> <cfformgroup>
<cfformitem> <cfftp> <cffunction> <cfgrid> <cfgridcolumn>
<cfgridrow> <cfgridupdate> <cfheader> <cfhtmlhead> <cfhttp>
<cfhttpparam> <cfif> <cfimage> <cfimport> <cfinclude>
<cfindex> <cfinput> <cfinsert> <cfinterface> <cfinvoke>
<cfinvokeargument> <cflayout> <cflayoutarea> <cfldap> <cflocation>
<cflock> <cflog> <cflogin> <cfloginuser> <cflogout> <cfloop>
<cfmail> <cfmailparam> <cfmailpart> <cfmenu> <cfmenuitem>
<cfmodule> <cfNTauthenticate> <cfobject> <cfobjectcache> <cfoutput>
<cfparam> <cfpdf> <cfpdfform> <cfpdfformparam> <cfpdfparam>
<cfpdfsubform> <cfpod> <cfpop> <cfpresentation> <cfpresentationslide>
<cfpresenter> <cfprint> <cfprocessingdirective> <cfprocparam>
<cfprocresult> <cfproperty> <cfquery> <cfqueryparam> <cfregistry>
<cfreport> <cfreportparam> <cfrethrow> <cfreturn> <cfsavecontent>
<cfschedule> <cfscript> <cfsearch> <cfselect> <cfset>
<cfsetting> <cfsilent> <cfslider> <cfsprydataset> <cfstoredproc>
<cfswitch> <cftable> <cftextarea> <cfthread> <cfthrow> <cftimer>
<cftooltip> <cftrace> <cftransaction> <cftree> <cftreeitem>
<cftry> <cfupdate> <cfwddx> <cfwindow> <cfxml> <cfzip>
<cfzipparam>