--=====================_24878715==_.ALT
Content-Type: text/plain; charset="us-ascii"
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.
Excuse my lack of knowledge about caching queries...
At 04:19 PM 8/1/00 -0500, Dana Larose wrote:
>Hi Peter,
>
>I asked this question a month ago, and here is one of the responses I
>recieved:
>(from Dan Haley, I believe)
>
>"The easiest way to cache the query is with the 'cachedwithin' attribute of
><cfquery>. For example <cfquery name="myQuery" datasource="myDataSource"
>cachedwithin="#createtimespan(0,0,30,0)#"> would cache your query for 30
>minutes. The only time the page will be slowed down is every 30 minutes
>when the query refreshes, and the caching time can be changed easily
>depending on how often your data changes.
>
>For displaying 10 rows at a time, use the 'startrow' and 'maxrows'
>attributes of <cfoutput>. <cfoutput query="myQuery" startrow="11"
>maxrows="10">.
>
>There are other ways to do this, but if this meets your needs it is most
>likely the simplest."
>
>Dana
>
>------------------------------------------------------------------------------
>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.
---------------------------------------------------------------------------
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 Fax 1.212.679.8032
--=====================_24878715==_.ALT
Content-Type: text/html; charset="us-ascii"
<html>
<font size=3>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.<br>
<br>
Excuse my lack of knowledge about caching queries...<br>
<br>
<br>
At 04:19 PM 8/1/00 -0500, Dana Larose wrote:<br>
<blockquote type=cite cite>Hi Peter,<br>
<br>
I asked this question a month ago, and here is one of the responses
I<br>
recieved:<br>
(from Dan Haley, I believe)<br>
<br>
"The easiest way to cache the query is with the 'cachedwithin'
attribute of<br>
<cfquery>. For example <cfquery name="myQuery"
datasource="myDataSource"<br>
cachedwithin="#createtimespan(0,0,30,0)#"> would cache your
query for 30<br>
minutes. The only time the page will be slowed down is every 30
minutes<br>
when the query refreshes, and the caching time can be changed
easily<br>
depending on how often your data changes.<br>
<br>
For displaying 10 rows at a time, use the 'startrow' and 'maxrows'<br>
attributes of <cfoutput>. <cfoutput
query="myQuery" startrow="11"<br>
maxrows="10">.<br>
<br>
There are other ways to do this, but if this meets your needs it is
most<br>
likely the simplest."<br>
<br>
Dana<br>
<br>
------------------------------------------------------------------------------<br>
Archives:
<a href="http://www.mail-archive.com/[email protected]/"
eudora="autourl">http://www.mail-archive.com/[email protected]/</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>
--=====================_24878715==_.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.
