--=====================_11296801==_.ALT
Content-Type: text/plain; charset="us-ascii"
Wow...
How does one acquire this kind of knowledge :-)
So my cached queries are safe to use. Each user will have his own cached query, even
though they are not attached to a "session" scope in any way. Except when two users
issue the exact same set of criteria in which case, in an even better win, they share
a cached query since their results will be the same anyway.
Excellent.
At 09:09 PM 8/1/00 -0400, Dave Watts wrote:
>> Does Cold Fusion cache queries separately for each user
>> session? ie: if 1000 users use this cached query they are all
>> searching with different values so the queries must be kept separate.
>
>If you cache queries using the CACHEDWITHIN or CACHEDAFTER attributes, CF
>stores each query in memory, and only reuses it if all of the other
>attributes of the CFQUERY tag are identical, and if the SQL statement itself
>is identical. So, if your script is allowing people to build their own
>queries by example, CF will only reuse a query if another user previously
>ran the same SQL statement.
>
>If you cache queries in memory variables (Session, Application, Server),
>then a query will be reused if you reference the variable containing it. If
>each user ran an SQL statement, and you stored the query in a Session
>variable, each user would have their own Session variable containing their
>own query.
>
>Dave Watts, CTO, Fig Leaf Software
>http://www.figleaf.com/
>voice: (202) 797-5496
>fax: (202) 797-5444
---------------------------------------------------------------------------
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 Fax 1.212.679.8032
--=====================_11296801==_.ALT
Content-Type: text/html; charset="us-ascii"
<html>
<font size=3>Wow...<br>
How does one acquire this kind of knowledge :-)<br>
<br>
So my cached queries are safe to use. Each user will have his own cached
query, even though they are not attached to a "session" scope
in any way. Except when two users issue the exact same set of criteria in
which case, in an even better win, they share a cached query since their
results will be the same anyway.<br>
<br>
Excellent.<br>
<br>
At 09:09 PM 8/1/00 -0400, Dave Watts wrote:<br>
<blockquote type=cite cite>> Does Cold Fusion cache queries separately
for each user<br>
> session? ie: if 1000 users use this cached query they are all<br>
> searching with different values so the queries must be kept
separate.<br>
<br>
If you cache queries using the CACHEDWITHIN or CACHEDAFTER attributes,
CF<br>
stores each query in memory, and only reuses it if all of the other<br>
attributes of the CFQUERY tag are identical, and if the SQL statement
itself<br>
is identical. So, if your script is allowing people to build their
own<br>
queries by example, CF will only reuse a query if another user
previously<br>
ran the same SQL statement.<br>
<br>
If you cache queries in memory variables (Session, Application,
Server),<br>
then a query will be reused if you reference the variable containing it.
If<br>
each user ran an SQL statement, and you stored the query in a
Session<br>
variable, each user would have their own Session variable containing
their<br>
own query.<br>
<br>
Dave Watts, CTO, Fig Leaf Software<br>
<a href="http://www.figleaf.com/" eudora="autourl">http://www.figleaf.com/</a><br>
voice: (202) 797-5496<br>
fax: (202) 797-5444</font></blockquote><br>
<font size=2><b><br>
---------------------------------------------------------------------------<br>
Peter Theobald, </b>Chief Technology Officer<br>
</font><font size=3 color="#0000FF"><b>LiquidStreaming
</b></font><a href="http://www.liquidstreaming.com/" eudora="autourl"><font size=2
color="#0000FF"><u>http://www.liquidstreaming.com</a><br>
</u></font><font size=2>[EMAIL PROTECTED]<br>
<b>Phone</b> 1.212.545.1232 <b>Fax</b> 1.212.679.8032<br>
</font></html>
--=====================_11296801==_.ALT--
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
