paul smith wrote: > At 12:21 PM 1/23/03 +0100, you wrote: > >>Just some thoughts: >>- query caching does not necessarily have to happen through the cfquery tag > > Are you referring to normal DB caching?
No. Just do a query and store the query in the application or session scope. >>- you could use multiple logins to the database, a readonly login and a normal >>one for instance > > Tell me more. Define more as 1 login. Use the readonly login from all the public templates, and the one with full access from an administrative interface. >>- use something not CF to update the database > > Such as? Anything that talks ODBC, JDBC or the native protocol of your rdbms. It could even be Access running from your computer at home. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
