> I am assuming that if multiple pages hit the same cached
> query, Cold Fusion internally handles it correctly without
> me locking it?? But then again, I would have assumed it
> would handle session variables correctly also if I didn't
> subscribe to cf-talk:)
>
> I am thinking: what happens if I have a large dataset being
> cached.... and what happens when it expires.. the next page
> to hit it has to re-run the query. While that query is executing,
> other pages are still reading it.
According to Allaire, there's no need to lock cached queries. In my personal
experience, I haven't seen any problem when using cached queries without
locks as I have with memory variables.
I'd guess that the CF engine doesn't read a query from the cache unless it's
been put there in its entirety. This is just a guess, of course.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
