Ryan, For the highest throughput, you're right of course. But even a modest hardware configuration can easily handle thousands of database queries per second. Do you really need to avoid hitting the database?
Jaime > -----Original Message----- > From: Ryan J. Heldt [mailto:[EMAIL PROTECTED] > Sent: Thursday, 16 October 2008 12:09 AM > To: cf-talk > Subject: Re: Sharing Data Between Applications > > Hey, thanks for responding. Creating a shared data source > like you mention would work, however this this data I'm > wanting to share is probably going accessed on every page > request, so hitting the database on every request is > something I would like to try to avoid, if possible. > > *Ryan J. Heldt*, Senior Web Developer > Global Reach Internet Productions > http://www.globalreach.com > Phone: 515-296-0792, Fax: 515-296-3748 > > > Jason Fisher wrote: > > To clarify a bit on Adrian's suggestion, allow the other > applications to access the database of the core management > application. One suggestion is to create a read-only > datasource to that database and use that new DSN when > accessing from the 'other' applications. > > > > Example: > > adminSource: datasource with full INSERT, UPDATE, DELETE > access, used > > by core app > > adminReader: datasource with SELECT / proc access ONLY, > used by other > > apps > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313956 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
