> > > Is the cached query limit on a per server basis or per
> > > application basis?
> >
> > i believe it is 100 queries per server. -emily
>
> Is there any way around the 100 query caching limit? For a
> big site, this sounds rather, er, limiting.
Actually, it seems that there isn't a limit at 100 queries per server. I'd
been told that in the past, but hadn't tested it until now. I used this as a
test script, then ran it twice:
<html>
<head>
<title>How many?</title>
</head>
<body>
<CFSET NumberOfQueries = 210>
<CFLOOP INDEX="i" FROM="1" TO="#NumberOfQueries#">
<CFQUERY NAME="q#i#" DATASOURCE="FastTrack_Solution"
CACHEDWITHIN="#CreateTimeSpan(0,0,10,0)#">
SELECT COUNT(*)
FROM Beans
WHERE Bean_ID < #i#
</CFQUERY>
</CFLOOP>
</body>
</html>
I set my machine to 200 queries in CF Administrator, then played around with
different values for "NumberOfQueries". Anything up to 200 queries were
cached, but if I attempted to cache more, then reload the page, the debug
output showed that the first ones would be pushed out of the cache. This
seems to indicate that you can, in fact, set more than 100 queries. I don't
know what the upper level might be, if there is one.
However, you'll want to be a bit less cavalier when you set this in "real
life", as your queries are likely to consume more memory than one record per
recordset. Watch memory utilization very carefully - if you can, test your
upper limit using a load test tool.
Finally, I'd like to point out that many kinds of "what if" questions,
commonly asked on the list, are best answered with five minutes of testing.
I realize that many people on the list might not want to do that, but the
alternative is that you may receive incorrect answers. Emily Kim, who
answered your question for example, is very knowledgeable, but she (and I)
have been under the misapprehension that there's a 100 query cap. I seem to
recall hearing this bandied about during a discussion with Allaire folks,
who probably said "I think that you can set it to 100" - and we heard that
as "You can set it to 100". If I hadn't been taking a break from doing
productive stuff (apparently, I take these breaks far too often), I'd have
kept my assumption that there in fact was a 100 query limit.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
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.
