Hi Dale,
That looks good, but how would that work with race conditions?
On 1/29/07, Dale Fraser <[EMAIL PROTECTED]> wrote:
>
> You could try it, but your probably right creating a new instance every
> time might be slower.
>
>
>
> However if you create an instance of the SQL object at application level,
> this might be even quicker than inline as it's already in the server's
> memory.
>
>
>
> <cfset application.sql = createObject('component', 'com.company.sql.Sql')
> />
>
>
>
>
>
> Then from any page you could do something like
>
>
>
> <cfset resultQuery = application.sql.executeSp('spName') />
>
>
>
> etc
>
>
>
> Regards
> Dale Fraser
>
>
> ------------------------------
>
> *From:* [email protected] [mailto:[EMAIL PROTECTED] *On
> Behalf Of *Taco Fleur
> *Sent:* Monday, 29 January 2007 6:18 PM
> *To:* [email protected]
> *Subject:* [cfaussie] putting queries in cfcs or not....
>
>
>
> We are working on an application that will receive high traffic.
>
>
>
> All queries are Stored Procedures (MS SQL 2005) and I was thinking of
> putting all the calls to those SPs in a CFC, only to keep all the SQL in one
> place. But since I am more concerned about speed than anything else, I am
> thinking this might not be the best way to go.
>
>
>
> I am leaning more towards putting the calls to the stored procedures
> inline the code now. Any input on this is much appreciated.
>
> --
> Taco Fleur - http://www.pacificfox.com.au
> Web Design, Web development, Graphic Design and Complete Internet
> Solutions
> an industry leader with commercial IT experience since 1994
>
>
>
> >
>
>
--
Taco Fleur - http://www.pacificfox.com.au
Web Design, Web development, Graphic Design and Complete Internet Solutions
an industry leader with commercial IT experience since 1994
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"cfaussie" 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/cfaussie?hl=en
-~----------~----~----~----~------~----~------~--~---
