if performance is the question, load testing is the answer. If even
simple load testing is too much work, then it's fast enough. :)
cheers,
barneyb
On 11/15/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Hi All,
>
> I am using a "Query Factory" component for all queries for my big
> Application. I want to know is it good or bad to use in place of
> CFquery as performance wise.
>
> I am using same kind of process for Object Factory. so its good or bad
> performance wise?
> Pls advice.
> Here is the code for QueryFactory
> --------------------------------------------------
>
> <!----
>
> <cfcomponent output="false" hint="query factory"
> extends="exception.load">
>
> <cfscript>
> init();
> </cfscript>
>
> <cffunction name="init" access="public" output="false"
> returntype="any" hint="Initialize the query factory object">
> <cfargument name="DSN" required="false" type="any"
> default="DSNOfApp" hint="DSN for query" />
> <cfset var dsn = Arguments.DSN>
>
> <cfscript>
> if (trim(dsn) eq "")
> {
> dsn="defaultdsnforyourapplication";// default
> dsn for ur
> application
> }
> setDSN(DSN);
> setQueryString("");
> </cfscript>
> </cffunction>
>
> <cffunction name="getType" access="public" returntype="any"
> output="false" hint="Returns the objects type">
> <cfreturn "utility.queryFactory" />
> </cffunction>
>
> <cffunction name="setDSN" access="private" output="false"
> returntype="void" hint="Sets DSN for query">
> <cfargument name="newDSN" type="string" required="true" />
> <cfSet Variables.DSN = Arguments.newDSN />
> </cffunction>
>
>
>
> <cffunction name="getDSN" access="private" output="false"
> returntype="any" hint="Gets DSN for query">
> <cfscript>
> if (isDefined('Variables.DSN')){
> return Variables.DSN;
> }else{
> return '';
> }
> </cfscript>
> </cffunction>
>
> <cffunction name="setQueryString" access="public" output="false"
> returntype="void" hint="Sets sql statements for query">
> <cfargument name="newQueryString" type="string" required="true"
> />
> <cfSet Variables.QueryString = Arguments.newQueryString />
> </cffunction>
>
> <cffunction name="getQueryString" access="public" output="false"
> returntype="any" hint="Gets sql statements for query">
> <cfscript>
> if (isDefined('Variables.QueryString')){
> return Variables.QueryString;
> }else{
> return '';
> }
> </cfscript>
> </cffunction>
>
> <cffunction name="getResultSet" access="public" output="false"
> returntype="any" hint="Gets the resultset">
> <cfscript>
> if (isDefined('variables.resultSet')){
> return variables.resultSet;
> }else{
> return '';
> }
> </cfscript>
> </cffunction>
>
> <cffunction name="setResultSet" access="private" output="false"
> returntype="any" hint="Sets the resultset">
> <cfargument name="newResultSet" type="any" required="true" />
> <cfset variables.resultSet = Arguments.newResultSet>
> </cffunction>
>
> <cffunction name="execute" access="public" output="false"
> hint="executes the query">
> <cfset variables.qry="">
>
> <cfquery name="qry" datasource="#getDSN()#">
> #getQueryString()#
> </cfquery>
>
> <cfscript>
> setResultSet(variables.qry);
> </cfscript>
>
> </cffunction>
>
> </cfcomponent>
>
>
> >
>
--
Barney Boisvert
[EMAIL PROTECTED]
http://www.barneyb.com/
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CFCDev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cfcdev?hl=en
-~----------~----~----~----~------~----~------~--~---
