Re: cached views

2004-03-19 Thread Jamie Jackson
On Fri, 5 Mar 2004 07:58:15 -0600, in cf-talk you wrote: - Original Message - From: Jamie Jackson I don't know if this is related, but if I've got a view (using *) that depends on other views, and I alter a sub-view, I get column caching even directly within enterprise manager. I put

Re: cached views

2004-03-05 Thread Deanna Schneider
Well, it never happened with 5.0, so while Oracle might be caching the view somehow, I don't think it's the only issue. - Original Message - From: Ben Doom I suspect that it's not CF -- it's the DB caching the view.Views are stored optimized queries, basically, so they would contain

Re: cached views

2004-03-05 Thread Deanna Schneider
- Original Message - From: Jamie Jackson I don't know if this is related, but if I've got a view (using *) that depends on other views, and I alter a sub-view, I get column caching even directly within enterprise manager. I put a utility in my app to call a view cache-clearing sproc

cached views

2004-03-04 Thread Deanna Schneider
Hey All, So, I've discovered that CF seems to be caching queries whether or not I want it to. So, for instance, I have a query like so: SELECT* FROMY If Y is a view and I change the view to add a new column, I have to add something like WHERE 1=1 to force it to see the new view. If I take the

RE: cached views

2004-03-04 Thread Douglas.Knudsen
, 2004 5:08 PM To: CF-Talk Subject: cached views Hey All, So, I've discovered that CF seems to be caching queries whether or not I want it to. So, for instance, I have a query like so: SELECT* FROMY If Y is a view and I change the view to add a new column, I have to add something like WHERE 1=1

Re: cached views

2004-03-04 Thread Ben Doom
I suspect that it's not CF -- it's the DB caching the view.Views are stored optimized queries, basically, so they would contain column information.The optimization includes keeping a stored list rather than detecting all columns every time. --Ben Doom Deanna Schneider wrote: Hey All, So,

Re: cached views

2004-03-04 Thread Jamie Jackson
I don't know if this is related, but if I've got a view (using *) that depends on other views, and I alter a sub-view, I get column caching even directly within enterprise manager. I put a utility in my app to call a view cache-clearing sproc to rememedy this. However, if you don't want to go