Yep! It appears so here, too. Cool.
Caching the following:
SELECT ID,Heading_ID,Heading_Name,Pages
FROM YellowPages (nolock)
WHERE Heading_Name LIKE '#attributes.alpha#%'
(ID & Heading_ID int, Heading & Pages varchar )
for 7,071 Headings increased CF ram by .9MB
I'll have to re-evaluate storing these data
in an Application Structure (Plan A), and
then using BLOCKFACTOR=100 to speed things up.
best, paul
At 08:32 AM 7/28/00 -0700, you wrote:
>It is my understanding (and it was born out by experimentation) that
>CF Query caching will cache the same-named query 26 different times,
>because the query itself, is different.
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
