> 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 Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:304296 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
