> Does Cold Fusion cache queries separately for each user
> session? ie: if 1000 users use this cached query they are all
> searching with different values so the queries must be kept separate.
If you cache queries using the CACHEDWITHIN or CACHEDAFTER attributes, CF
stores each query in memory, and only reuses it if all of the other
attributes of the CFQUERY tag are identical, and if the SQL statement itself
is identical. So, if your script is allowing people to build their own
queries by example, CF will only reuse a query if another user previously
ran the same SQL statement.
If you cache queries in memory variables (Session, Application, Server),
then a query will be reused if you reference the variable containing it. If
each user ran an SQL statement, and you stored the query in a Session
variable, each user would have their own Session variable containing their
own query.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
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.
