I am, however, considering caching options as it related to both queries and records. I'm not quite sure how this would work yet though.
Doug, please forgive my 2 cents but while caching SQL/DML makes perfect sence (not too far removed from execution plans, methinks) going the extra step with cached data and knowing when it's dirty if more than one application can access the same database has done my head in far too many times. Client-server app with an alternative web front end; 2 applications accessing the same database; even legacy Vs new code, etc. just a quick thought, nothing more. cheers barry.b -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
