possibly be that the app is exceeding the number of cached queries as set in
the administrator. I also heard at the DevCon2001 that CFQUERY does not
scale very well in large cf sites. I think this might also be the case
here.
If I get to the root of the evil here, I will let you know.
Thanks
Has anyone seen the following error:
CFQuery
Retrieval of cached query failedpThe error occurred while processing an
element with a general identifier of (CFQUERY), occupying document position
(401:3) to (401:153) in the template file
I have posted this on the forums, but have not got a
Let me get this right, if I set cachedWithin to 24 hours, and set 100 cached
queries in the server, the server limit will 'win' if a 101st query is made,
and the oldest query will be uncached ?
Regards,
Thomas Chiverton
Intranet Architect
01565 757 909
The web is the borderless embodiment
Thomas Chiverton wrote:
Let me get this right, if I set cachedWithin to 24 hours, and set 100 cached
queries in the server, the server limit will 'win' if a 101st query is made,
and the oldest query will be uncached ?
Correct.
Jochem
What's the best way to clear out a cached query, so that your
production site will use the most current database information? I want
to retain my long cache spans on a production box, but I want to be
able to update or refresh the queries at will.
Here is my current process:
1. Break the
(Please pardon the doubled post, newsgroup users)
What's the best way to clear out a cached query, so that your
production site will use the most current database information? I want
to retain my long cache spans on a production box, but I want to be
able to update or refresh the queries at
variable. The reason they reload is that the SQL has changed
(but the result set will not change).
Craig
-Original Message-
From: Jamie Jackson [SMTP:[EMAIL PROTECTED]]
Sent: Friday, June 01, 2001 12:03 PM
To: CF-Talk
Subject: Best way to clear Cached Queries?
What's the best
each time called...no extra spaces
anywhere.
Ken
-Original Message-
From: Jamie Jackson [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 01, 2001 12:03 PM
To: CF-Talk
Subject: Best way to clear Cached Queries?
What's the best way to clear out a cached query, so that your
production site
/
--
-Original Message-
From: Jamie Jackson [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 01, 2001 12:03 PM
To: CF-Talk
Subject: Best way to clear Cached Queries?
What's the best way to clear out a cached query, so that your
production site will use the most current database
]]
Sent: Friday, June 01, 2001 12:03 PM
To: CF-Talk
Subject: Best way to clear Cached Queries?
What's the best way to clear out a cached query, so that your
production site will use the most current database information? I want
to retain my long cache spans on a production box, but I want
Probably obvious, but...
I do believe it's based on the entire *exact* contents of the
cfquery tag.
One simple change effectively makes it a different
query...even just adding
a space to it.
so if you want to use a cached query in more than one place, CFINCLUDE
it.
That way, you
so if you want to use a cached query in more than one place, CFINCLUDE
it.
That way, you know all instances of that query are going to be identical.
Yep...like all good Fuseboxers do. :)
Also makes it trivial to flush that cached query after doing an
add/delete/update that would
Is there a limit the physical number of queries that can be cached by CF? I
know one of the limiting factors is that amount of RAM, but I thought I
heard some where that there was a limit of 100 queries.
Duane
~~
Structure your ColdFusion code
Message-
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 11, 2001 12:41 PM
To: CF-Talk
Subject: Cached Queries
Is there a limit the physical number of queries that can be
cached by CF? I
know one of the limiting factors is that amount of RAM, but I thought I
heard some
Great thanks!
Duane
-Original Message-
From: Cameron Childress [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 11, 2001 1:08 PM
To: CF-Talk
Subject: RE: Cached Queries
Take a peek in the CFAdmin and you will see that there is a setting for max
number of queries. I think the default
Quick question on cached queries:
Are queries cached and retrieved from cache based on the query name or the
SQL within the query?
Duane
-Original Message-
From: Cameron Childress [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 11, 2001 1:08 PM
To: CF-Talk
Subject: RE: Cached Queries
I do believe it's based on the entire *exact* contents of the cfquery tag.
One simple change effectively makes it a different query...even just adding
a space to it.
Ken
Quick question on cached queries:
Are queries cached and retrieved from cache based on the query name or the
SQL within
Thanks
Duane
-Original Message-
From: Ken Wilson [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 11, 2001 1:26 PM
To: CF-Talk
Subject: RE: Cached Queries
I do believe it's based on the entire *exact* contents of the cfquery tag.
One simple change effectively makes it a different query
of having another page in an
administration area that has all the cached queries in it, except the
cachedwithin timespan is set to zero on these. Ad administrator would
execute this page, clearing all the cached queries (As long as they all
made their way in to this list).
How does this sound?
Does
CFOBJECTCACHE ACTION="CLEAR"
will clear all the cached queries on the server.
Undocumented and unsupported
P.
-Original Message-
From: Ryan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 07, 2001 4:20 PM
To: CF-Talk
Subject: Can you clear cached queries?
After looki
How do I define a cached query and then access it?
Problem is that I have a menu built off a query, the pages
built from those menu choices off other queries. Click too
many menu items too quickly and poof! The CF service reboots.
What would be the best way to handle this?
In CF 4.x,
Had some mail server problems, not sure if this went through...
How do I define a cached query and then access it?
Problem is that I have a menu built off a query, the pages built from those
menu choices off other queries. Click too many menu items too quickly and
poof! The CF service
How do I define a cached query and then access it?
Problem is that I have a menu built off a query, the pages built from those
menu choices off other queries. Click too many menu items too quickly and
poof! The CF service reboots. What would be the best way to handle this?
Can I set a query
some database activity (and database traffic) as well as being
able to perform database operations not possible with straight database
calls.
--- Ben
-Original Message-
From: Jennifer [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 02, 2001 2:19 PM
To: CF-Talk
Subject: cached queries
I'd like to see some statistics on cached queries vs. querying a
structure.
It would entirely depend on who you are planning on using your data. It's
like comparing apples and oranges.
Incidentally, a query in CF can be treated like a structure already. You
can pull records out of a query
PROTECTED]]
Sent: Friday, February 02, 2001 2:38 PM
To: CF-Talk
Subject: RE: cached queries vs. structures was(Re: ...BETA...!! (query a
query))
I'd like to see some statistics on cached queries vs. querying a
structure.
It would entirely depend on who you are planning on using your data. It's
At 02:38 PM 2/2/01 -0500, you wrote:
I'd like to see some statistics on cached queries vs. querying a
structure.
It would entirely depend on who you are planning on using your data. It's
like comparing apples and oranges.
Yes, but if I could get some idea what the difference in performance
I believe we have to define the problem more accurately, and then test the
alternatives, to determine which way to go: Structures vs Cached Queries.
I accidently tested Structures vs Cached Queries on a Yellow Pages
application. I had planned to use Structures, but developed the app both
p.770.460.7277.232
f.770.460.0963
-Original Message-
From: Jennifer [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 02, 2001 3:36 PM
To: CF-Talk
Subject: RE: cached queries vs. structures was(Re: ...BETA...!! (query a
query))
At 02:38 PM 2/2/01 -0500, you wrote:
I'd like to
fairly quickly.
-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Sunday, November 12, 2000 8:32 AM
To: CF-Talk
Subject: Re: [Cached Queries]
On 11/12/00, W Luke penned:
Excellent. I basically have 2 queries that both return large amounts of
records - the first being as you
On 11/11/00, pan penned:
As a final test to see if reformatted sql affects
caching I repeated A B with the difference that
afetr a restart I excluded the reformatted sql call
from the template but included it within B. Result
is that Bud is absolutely right. My mistake was that
I have a machine
They are cached by name, search parameters, and also by the query
structure itself.
So
SELECT product_name
FROM products
and
SELECT product_name FROM products
would be read as 2 separate queries because the structure is
different, even if they are named the same.
Oh I see -
On 11/12/00, W Luke penned:
Excellent. I basically have 2 queries that both return large amounts of
records - the first being as you describe above - however the second is an
interesting dilema. I have a table called Locations, with "County" and
"Town." Using the cool TwoSelectsRelated tag,
I tried using it in my shopping cart also for countries and
states/territories. It was dreadfully slow, because of the huge
amount of javascript code that had to be loaded, and didn't work at
times probably due to the same thing. I ended up just going to an
extra screen to choose the state
On 11/10/00, Alex penned:
i think they are cached according to the queryname. so if you name the query
with a sessionid you could have them cached per user.
and YES they will make the page faster for the end user.
i cache all static querys.
They are cached by name, search parameters, and also
From: "Bud" [EMAIL PROTECTED]
Subject: Re: [Cached Queries]
On 11/10/00, Alex penned:
i think they are cached according to the queryname. so if you name the query
with a sessionid you could have them cached per user.
and YES they will make the page faster for the end user.
i
eehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
--_-1238158479==_ma
Content-Type: text/html; charset="us-ascii"
!doctype html public "-//W3C/
From: "Bud" [EMAIL PROTECTED]
Subject: Re: [Cached Queries]
[results of sql formatting changes on caching]
Interesting.
Before I replied that it wasn't true I also had run
the same type of test. As you can see from the debug
output (A) below the differently typed sql also
cached
Interesting.
B shows you were right, but also shows something
else. The first cachedwithin call after the intial
query did not produce cached results on a
freshly restarted machine.
Good work boys. Just watching this discussion is making my brain itchy : )
Hi,
I'm quite interested in caching a couple of queries, of 1500 records or
more, using the CachedWithin attribute. Can anyone tell me whether queries
are cached on a per-user/session basis, or "globally" for all users? I
understand it might reduce loads on the server - but what about end-user
ope.
Andrew Hewitt
Web Application Developer
webworld studios, inc.
www.wwstudios.com
-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 10, 2000 7:25 PM
To: CF-Talk
Subject: Cached Queries
Hi,
I'm quite interested in caching a couple of queries, of
i think they are cached according to the queryname. so if you name the query
with a sessionid you could have them cached per user.
and YES they will make the page faster for the end user.
i cache all static querys.
"W Luke" [EMAIL PROTECTED] wrote:
Hi,
I'm quite interested in caching a couple
c.
www.wwstudios.com
-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 10, 2000 7:25 PM
To: CF-Talk
Subject: Cached Queries
Hi,
I'm quite interested in caching a couple of queries, of 1500 records
or
more, using the CachedWithin attribute. Can anyone tel
Has there been any debate as to whether or not to store lookup table
information as application variables, or to use cached queries to retrieve
that information? Common sense would dictate that application scope
variables would use less space, but then you have to implement some shared
memory
At 09:39 PM 10/6/00 -0600, you wrote:
Is it advisable to use locking when referencing a cached query? I would
assume a cached query fits the bill of being shared data. If so, then
wouldn't the lock need to be around the cfquery statment as well as
references to any query values?
You don't need
Is it advisable to use locking when referencing a cached
query? I would assume a cached query fits the bill of being
shared data. If so, then wouldn't the lock need to be around
the cfquery statment as well as references to any query
values?
If you're referring to queries cached with
Does this mean that CF implicitly creates a copy of the
cached query (query variable foo, above) for every template
that references the query or will CF only do this if a
template modifies the data within the query?
I don't have enough knowledge of the internals of the CF engine to say
Is it advisable to use locking when referencing a cached query? I would
assume a cached query fits the bill of being shared data. If so, then
wouldn't the lock need to be around the cfquery statment as well as
references to any query values?
Does modifying the contents of a cached query
Perhaps your syntax for setting this.attribute wasn't right? This should
work.
cfset this = StructNew()
cfset this.attribute = "color"
cfquery datasource=#dsn# name="#this.attribute#attributes"
cachedafter=#DateAdd('d', '-1', Now())#
SELECT *
FROM
The purpose of my posting was
a heads up to those folks who really
know how to do this sort of thing.
But what I have done is a valid
indicator for my app. That is, I
was attempting to hold all things
constant except how the data was
stored in/read from memory.
In addition, consider the
important for reads.
best, paul
At 12:48 PM 8/31/00 -0400, you wrote:
And since Cached queries are read only
is it even really fair to compare the two
given how easy it is to set and work with
a structure and the somewhat more limiting
nature of cached queries?
Paul Smith, Web/Database Droid
Interesting. FindNoCase had an effect on the Structure but
not the Cached version. Structure still slower, 194/180 = 8%
instead of 15%.
best, paul
At 11:42 AM 8/31/00 -0500, you wrote:
As an aside, I'd be curious to know how FindNoCase would affect processing
time if you replaced "eq" and
This came up in the last two days.
Check the archives.
best, paul
At 12:31 PM 8/31/00 -0500, you wrote:
Additionally, a question: I've never had any problems with just
sticking data in a structure, but without "creating" the structure using
StructNew().. does anyone know what the
These CFSETs are one-time, when App is first accessed.
Their ms is not included in the timings I posted.
best, paul
At 12:31 PM 8/31/00 -0500, you wrote:
ewww... I hate long blocks of cfset's :)
Use cfscript instead when you have all those cfsets.. that'll speed
things up some more.
Try CompareNoCase. ;)
-Original Message-
From: paul smith [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 31, 2000 2:40 PM
To: [EMAIL PROTECTED]
Cc: Andy Peterson
Subject: Re: Structures No? Cached Queries Yes?
Interesting. FindNoCase had an effect on the Structure
Brief test. I doubted, so I tried. At first I was a little misled... then
realized I wasn't testing properly. ;) Don't try doing this with a loops...
loops throw it off. And be sure to reset the ticks between each test.
CFSET x = 1 times:
1 cfset: 0 milliseconds
10 cfsets: 0 milliseconds
100
OK, gonna jump in on this one now.
I don't use cached queries. I use scoped queries. Essentially the same
thing, but I like managing my own caching rather than allowing the server
to determine what gets cached (based on the rotating list of "last used").
Just a preference.
But on t
y
New York into a structure, all Listings in Newark into
another structure, and so forth.
Is this the idea? Do you have any specific suggestions
for Yellow Pages?
best, paul
At 09:18 PM 9/1/00 -0400, you wrote:
OK, gonna jump in on this one now.
I don't use cached queries. I use scoped queries. E
all to the DB.
Another would be to load all Listings in one city, say
New York into a structure, all Listings in Newark into
another structure, and so forth.
Is this the idea? Do you have any specific suggestions
for Yellow Pages?
best, paul
At 09:18 PM 9/1/00 -0400, you wrote:
OK, gonna jump
I see my earlier post was obscure to opaque.
For the same results:
Get data from a cached query: Average = 180ms
Get data from a database stored in a Structure: Average = 227ms
Structure takes 26% longer than a cached query to get the same
data.
This kind of makes sense, since with a
-460-0963
-Original Message-
From: paul smith [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 31, 2000 9:06 AM
To: [EMAIL PROTECTED]
Subject: Structures No? Cached Queries Yes?
I see my earlier post was obscure to opaque.
For the same results:
Get data from a cached query
row MOD
columncount))#" TO="1" STEP="-1" INDEX="i"
TD/TD
/CFLOOP
/TR
/CFIF
/CFOUTPUT
/TABLE/DIV
best, paul
At 09:38 AM 8/31/00 -0400, you wrote:
I'd be interested in knowing what the code and data structure in your t
PROTECTED]]
Sent: Thursday, August 31, 2000 9:06 AM
To: [EMAIL PROTECTED]
Subject: Structures No? Cached Queries Yes?
I see my earlier post was obscure to opaque.
For the same results:
Get data from a cached query: Average = 180ms
Get data from a database stored in a Structure: Average = 227ms
age -
From: paul smith [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 31, 2000 11:03 AM
Subject: RE: Structures No? Cached Queries Yes?
I got the difference down to 15% by eliminating CFSETs
in the Structure version. (Structure still slower.)
Structure set a la the foll
or testing and benchmarking I would want to
measure the raw performance of nothing but
query reads on a page and nothing but
structure reads on a page, and then
do a presentation of the data.
All of the extraneous data and processing
done is not needed when benchmarking.
And since Cached quer
Administrator/Settings
Statement that:
"The maximum number of cached queries allowed at any given time is 100."
notwithstanding. (I notice CF4.0.1 accepted my limit of but not
1. Is there a message here?)
So IF the CF limit on Cached Queries is not limiting to your a
ewww... I hate long blocks of cfset's :)
Use cfscript instead when you have all those cfsets.. that'll speed
things up some more.
Additionally, a question: I've never had any problems with just
sticking data in a structure, but without "creating" the structure using
StructNew().. does anyone
Administrator/Settings
Statement that: "The maximum number of cached queries allowed at any given
time is 100."
notwithstanding. (I notice CF4.0.1 accepted my limit of but not
1. Is there a message here?)
I posed this question directly to Jeremy Allaire a few weeks ago a
/msg01168.html
HTH,
Robert Hinojosa
WebDeveloper
512.912.3775
[EMAIL PROTECTED]
www.cirrus.com
-Original Message-
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 31, 2000 12:31 PM
To: [EMAIL PROTECTED]
Subject: Re: Structures No? Cached Queries Yes?
ewww... I hate
-7277 x.232
f. 770-460-0963
-Original Message-
From: paul smith [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 31, 2000 9:06 AM
To: [EMAIL PROTECTED]
Subject: Structures No? Cached Queries Yes?
I see my earlier post was obscure to opaque.
For the same results:
Get
No. I was referring to eliminating CFSETs
at the output stage to set dummy variables
and using variables with Structure syntax
instead.
That is, eliminating steps like:
CFSET ClassID = APPLICATION.YPS["#Class_ID#"]
changed the Structure method to be only 15%
slower instead of 26% slower.
Hello all,
Is there any way to tell how much memory is being used by a cached query?
Matthew Taylor
Web Developer
www.UClick.com
617.868.0009
[EMAIL PROTECTED]
--
Archives:
. Functions
which would allow you to see total or average memory used by Sessions,
Cached Queries, Cached Templates, CF as an application, etc... So that you
could effectively break down the total memory usage of CF and see where it's
all going.
Or maybe this would be better placed in the CF
Hello all,
More questions regarding cached queries and SQL. Once a query is cached is
there a way to run SQL queries against it. I believe there is an ASP
function called 'disconnected recordsets' or something like that. Is there a
CF equivalent???
TIA
Matthew Taylor
Web Developer
parts of CF at any given time. Functions
which would allow you to see total or average memory used by Sessions,
Cached Queries, Cached Templates, CF as an application, etc... So that you
could effectively break down the total memory usage of CF and see where it's
all going.
Or maybe
Dana, set the cachedwithin time to 0.
(Still no city, eh?)
-David
If you are caching queries, is there a way to force CF
to flush them?
YOU'RE PAYING TOO MUCH FOR THE INTERNET!
Juno now offers FREE Internet Access!
Try it today
Hey everyone,
If you are caching queries, is there a way to force CF to flush them?
When an administrator updates a table, I would like CF to dump any cached
queries using that table, so that users aren't viewing old data.
Dana Larose
Web Developer
Canadian Web Design Consulting Inc.
A: 701
101 - 177 of 177 matches
Mail list logo