Well it's not what I would do, ever tried using the caching of the queries. Sure it might take 2.5 seconds the first time after that, 0 seconds to recall. Just don't need all the extra coding that you put into place that's all.
-----Original Message----- From: Alistair Davidson [mailto:[EMAIL PROTECTED]] Sent: Friday, 9 November 2001 11:02 PM To: CF-Talk Subject: RE: Session variables OK, here's one example - We have a system where a huge amount of config data needs to be retrieved from a database for each page. Just retrieving all the DB records takes about 2.5 seconds. If you were doing that every page, then you'll very quickly kill just about any server. So what we do is convert those DB records to structres, and store them in the Application scope. On each request, we check if the App structure exists, and if it doesn't (or if a particular parameter is passed in the url) call the code that initialises the structure. Then we duplicate the Application structure into the REQUEST scope, which only takes about 50 ms. how's that? -----Original Message----- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: 09 November 2001 11:31 To: CF-Talk Subject: RE: Session variables > There are legitimate uses for the Application scope. In what situations would you need to use the Application scope which couldn't be handled by the Request scope? I've never been able to think of any good examples. -- Aidan Whitehall <[EMAIL PROTECTED]> Macromedia ColdFusion Developer Fairbanks Environmental +44 (0)1695 51775 ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
