--=====================_12594321==_.ALT
Content-Type: text/plain; charset="us-ascii"
It turns out to be incorrect anyway.
The assumption here was that if you cache a query, then it is cached by NAME. This
means that if 1000 people do a search on the web site, the cache gets messed up
because they are all saving the same query into one cache. He suggested making up a
dynamically-generated DIFFERENT name for the query EACH time a user uses it. That way,
the 1000 people using the page at the same time will each have their own private
cached version of the query. (Queries are cached by the server globally, if you want
to think of them as having "scope" they are in the server scope, not the session
scope).
But what Dave Watts says is that you don't need to worry about this because it is not
an issue. Cold Fusion caches queries not only by NAME but also by the exact SQL of the
query. Therefore if 1000 users issue 1000 different searches with different criteria,
each query will have different SQL and thus be cached separately. If 2 users should
happen to issue exactly the same criteria then my code will build the same SQL and the
cached query will be shared, but that happens to be ok in this case, with my code,
because the users will be getting the same results anyway so having them share a
cached query is a performance GAIN.
At 08:38 PM 8/1/00 -0700, paul smith wrote:
>Could someone explain this please.
>
>best, paul
>
>At 03:02 PM 8/1/00 -0700, you wrote:
>>Perhaps use a dynamically-generated
>>query name so that two people hitting the page at the same time won't
>>overwrite each other's query results.
>
>------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>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.
---------------------------------------------------------------------------
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 Fax 1.212.679.8032
--=====================_12594321==_.ALT
Content-Type: text/html; charset="us-ascii"
<html>
<font size=3>It turns out to be incorrect anyway.<br>
<br>
The assumption here was that if you cache a query, then it is cached by
NAME. This means that if 1000 people do a search on the web site, the
cache gets messed up because they are all saving the same query into one
cache. He suggested making up a dynamically-generated DIFFERENT name for
the query EACH time a user uses it. That way, the 1000 people using the
page at the same time will each have their own private cached version of
the query. (Queries are cached by the server globally, if you want to
think of them as having "scope" they are in the server scope,
not the session scope).<br>
<br>
But what Dave Watts says is that you don't need to worry about this
because it is not an issue. Cold Fusion caches queries not only by NAME
but also by the exact SQL of the query. Therefore if 1000 users issue
1000 different searches with different criteria, each query will have
different SQL and thus be cached separately. If 2 users should happen to
issue exactly the same criteria then my code will build the same SQL and
the cached query will be shared, but that happens to be ok in this case,
with my code, because the users will be getting the same results anyway
so having them share a cached query is a performance GAIN.<br>
<br>
At 08:38 PM 8/1/00 -0700, paul smith wrote:<br>
<blockquote type=cite cite>Could someone explain this please.<br>
<br>
best, paul<br>
<br>
At 03:02 PM 8/1/00 -0700, you wrote:<br>
>Perhaps use a dynamically-generated<br>
>query name so that two people hitting the page at the same time
won't<br>
>overwrite each other's query results.<br>
<br>
------------------------------------------------------------------------------<br>
Archives:
<a href="http://www.mail-archive.com/cf-talk@houseoffusion.com/"
eudora="autourl">http://www.mail-archive.com/cf-talk@houseoffusion.com/</a><br>
To Unsubscribe visit
<a href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk"
eudora="autourl">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk</a>
or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
</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>
--=====================_12594321==_.ALT--
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.
