Re: [CFCDev] Gateway in Applicaton Scope : Slow Stored Proc Call

[Peter Hardy]

Thanks for the feedback Baz. In the end I worked it out. I'd set up a scheduled event that uses sqlxml to batch update the table in question. And it just so happens 40 or so page refreshes is exactly the amount of time between batch updates.

 

Or to put it another way, I'm a doodoo-head and I was running into locking issues.

 

Cheers  Pete (aka lad4bear)

 

On 26/11/05, Baz <[EMAIL PROTECTED]> wrote:

 

Perhaps your application is restarting and therefore re-creating all the application vars including your gateway. Or, perhaps your RAM is being consumed by other persistent scope data kicking out your gateway and forcing it to re-create.

 

Baz

 

 

---

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Peter Hardy
Sent: Friday, November 25, 2005 9:39 PM
To: CFCDev@cfczone.org
Subject: [CFCDev] Gateway in Applicaton Scope : Slow Stored Proc Call

 

Hi Guys,

 

I have a Gateway which is stored in application scope with the following method. It works fine 40 or so times, then for no apparent reason it will take 15 seconds to complete. Has anyone experienced similar problems when using a Gateway stored in application scope?

 

 <cffunction name="SelectMatchingHotelRates" access="public" returntype="query" output="true">
  <cfargument name="AgentId" type="string" required="yes">
  <cfargument name="AgentPassword" type="string" required="yes">
  <cfargument name="OptionList" type="string" required="yes">
  <cfargument name="Single" type="numeric" required="yes">
  <cfargument name="Double" type="numeric" required="yes">
  <cfargument name="Twin" type="numeric" required="yes">
  <cfargument name="Triple" type="numeric" required="yes">
  
   
   <cfset var results = "" />
   
   <cftry>
    <cfstoredproc procedure="SelectMatchingHotelRates" datasource="#variables.dsn#" returncode="no">
     <cfprocparam value="#arguments.AgentId#" type="in" cfsqltype="cf_sql_varchar" null="no">
     <cfprocparam value="#arguments.AgentPassword#" type="in" cfsqltype="cf_sql_varchar" null="no">
     <cfprocparam value="#arguments.OptionList#" type="in" cfsqltype="cf_sql_varchar" null="no">
     <cfprocparam value="#arguments.Single#" type="in" cfsqltype="cf_sql_integer" null="no">
     <cfprocparam value="#arguments.Double#" type="in" cfsqltype="cf_sql_integer" null="no">
     <cfprocparam value="#arguments.Twin#" type="in" cfsqltype="cf_sql_integer" null="no">
     <cfprocparam value="#arguments.Triple#" type="in" cfsqltype="cf_sql_integer" null="no">
     
     
     <cfprocresult name="results" />
    </cfstoredproc>

    <cfcatch type="database">
     <cfrethrow />
    </cfcatch>
   </cftry>

  <cfreturn results />
 </cffunction> 

Cheers Pete (aka lad4bear)

 

----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to cfcdev@cfczone.org with the words 'unsubscribe cfcdev' as the subject of the email.

CFCDev is run by CFCZone ( www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com).

An archive of the CFCDev list is available at www.mail-archive.com/cfcdev@cfczone.org

----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to cfcdev@cfczone.org with the words 'unsubscribe cfcdev' as the subject of the email.

CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting ( www.cfxhosting.com).

An archive of the CFCDev list is available at www.mail-archive.com/cfcdev@cfczone.org

----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to cfcdev@cfczone.org with the words 'unsubscribe cfcdev' as the subject of the email.

CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com).

An archive of the CFCDev list is available at www.mail-archive.com/cfcdev@cfczone.org