That was what I was afraid of. What I have done is serialzied the query and
stored the packet in a session variable. I tried that on a whim assuming it
would take too long to serialize/deserialize the query. But for a 3000 row
query it only takes about 300 msec which i can live with.
----- Original Message -----
From: "Garza, Jeff" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, June 21, 2001 9:25 AM
Subject: RE: Cache sp result set
> Yes, but you'll have to use CFQUERY to call your SP. So that limits you
to
> a single result set and you cannot use CFQUERYPARAM. Unless your
> recordset(s) are really large, you're better off using CFSTOREDPROC to
call
> the SP. I guess in a worst case scenario, you could store the query in a
> application or session scoped variable and call it from there...
>
> HTH,
>
> Jeff Garza
> Lead Developer/Webmaster
> Spectrum Astro, Inc.
> 480.892.8200
> [EMAIL PROTECTED]
> http://www.spectrumastro.com
>
>
>
> -----Original Message-----
> From: Don Vawter [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 20, 2001 9:52 PM
> To: CF-Talk
> Subject: Cache sp result set
>
>
> Is there any way to cache the result set returned by a stored proced in
SQL
> Server 2000, CF 5
>
> TIA
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
