I have recently started to do this cache user-specific queries on a
global basis by using dynamic query names, based upon data specific to a
user. So far, it seems to be working well.
Kevin
>>> [EMAIL PROTECTED] 11/10/00 04:52PM >>>
Will:
Using the CachedWithin attribute caches the query "globally" as
you put it.
If you want to cache queries on a per user bases you might want to make
the
query a session query. You can also accomplish "global" caching by
placing
the query into the application scope.
Andrew Hewitt
Web Application Developer
webworld studios, inc.
www.wwstudios.com
-----Original Message-----
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 10, 2000 7:25 PM
To: CF-Talk
Subject: Cached Queries
Hi,
I'm quite interested in caching a couple of queries, of 1500 records
or
more, using the CachedWithin attribute. Can anyone tell me whether
queries
are cached on a per-user/session basis, or "globally" for all users?
I
understand it might reduce loads on the server - but what about
end-user
speeds; will it speed up the users' request?
Any other thoughts, comments etc welcome.
Will
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
send a
message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
send a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
