I see your point about seeing more of a performance difference under load. And I think you're right about "something else changing" about the same time I cleared the cache. I believe I didn't delete all data from the table before inserting some duplicate data.
Thanks for the feedback! Rick > -----Original Message----- > From: Dave Watts [mailto:[EMAIL PROTECTED] > Sent: Saturday, April 26, 2008 10:29 PM > To: CF-Talk > Subject: RE: CachedWithin question... > > > I've just begun using "cachedwithin" and ran into an issue > > when running an insert query (not the one with the > > "cachedwithin" setting). > > > > I got a duplicate key error. I traced that down to the fact > > that I had used "cachedwithin" on another query (a select > > query) with a different name that involved the same data as > > the above mentioned insert query. > > > > Once I ran the select query with a cachedwithin setting of 0, > > the cache apparently cleared and the other insert query ran > > without any error. > > The existence of a cached query should have absolutely no effect on any > insert queries you run. I suspect there's another problem that simply went > away around the same time as your manually clearing the cache. Can you post > the exact error message you received? > > > This could get complicated. The "cachedwithin" setting is > > only shaving about 1 second off query results... from 2-3 for > > query and display, down to about 2 seconds. I'm wondering if > > having to run a query using "cachedwithin" with a 0 setting > > every time I want to insert data is worth it. > > The measure of any performance enhancement is how it works under normal > load. When you look at this, if you're the only one running the application, > you're unlikely to see a significant performance difference. That said, I > usually see more of a difference than that when casually observing the > application debug output. > > Dave Watts, CTO, Fig Leaf ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304298 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
