> automatically?
No, it doesn't.
> I can see using cfqueryparam in the second instance, but I
> don't see how it helps in the first and I don't see how using
> it caches my queries or improves performance. I looked at
> the CFDOCS and don't see any info about it auto-caching when
> using <cfqueryparam>. Any insight would be appreciated.
When you use CFQUERYPARAM, the database will generally cache query execution
plans, which can speed up future database queries using the same plan. It
doesn't have anything to do with caching recordsets in memory on your CF
server, though, and in fact you can't use CFQUERYPARAM with
CACHEDWITHIN/CACHEDAFTER.
For this reason, you might consider caching recordsets within persistent
memory variable scopes (Session/Application/Server) instead.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
