If your CF application can use cached queries to good effect, then doing so
will go a long way towards overcoming any problems with Access (since your
cached query resides in memory and CF doesn't use Access to access it).
You can use a Structure for the same purpose as a cached query. But as
someone mentioned here 2 or 3 weeks ago, a better use of a Structure might
be to store in it in de-normalized/de-normalised ;-) "projection/filtered
datasets" of the entire data than storing an entire table in it as it
exists in your DB. (Where the "projection/filtered datasets" answer
questions commonly answered by SQL queries.)
best, paul
At 04:18 PM 10/12/00 -0500, you wrote:
>any special caching techniques?
>
>I've finally figured out how to use stored procedures, but my site still
>seems slow..
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
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.
