> So on a server that only runs one application, they would > effectively be application-wide. Otherwise, with several > apps on one server, one would have to be careful on query > naming, by the sound of it.
This was posted on cf-talk yesterday: > -----Original Message----- > From: A Tamuri [mailto:[EMAIL PROTECTED] > Sent: 12 November 2003 16:51 > Subject: Custom tag to see list of cached queries! > > ... > > I have written a CFX custom tag for CFMX, called > cfx_queryCache, which allows you to get a list of all your > cached queries and flush individual queries based on its key. > > I'd be interested in any ideas for improvements, both > functionality and improving the Java code. It's open-source > and available from http://tamuri.cfdeveloper.co.uk/ >From the information on this page, the key that is used to store a cached query is based on "datasource + sql + name + username + password". Also note that the "sql" part of this is specific to the *exact* query, right down to whitespace... >From this, it means that the only time you're likely to be running the same query over multiple applications is if you're using a shared library or include and exactly the same datasource and parameters. In which case, you're after exactly the same data from both applications, so if wouldn't matter that you're retrieving the same info for both... Tim. ------------------------------------------------------- RAWNET LTD - Internet, New Media and ebusiness Gurus. Visit our new website at http://www.rawnet.com for more information about our company, or call us free anytime on 0800 294 24 24. ------------------------------------------------------- Tim Blair Web Application Engineer, Rawnet Limited Direct Phone : +44 (0) 1344 393 441 Switchboard : +44 (0) 1344 393 040 ------------------------------------------------------- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. ------------------------------------------------------- -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
